Page Comparison

...

A welcome screen is displayed

BUT WAIT! Before you can start using Power BI you need your Organizational Code this can be found Organisational Code for first time customers this code need to be setup, contact BUZ Support to supply your Organisational Code once you have been configured you can find your code in BUZ under Reports ->  Right hand side ( 5 character code) or contact BUZ Support to supply your Organizational Code . 

Power Bi (For Mac)

Power Bi does not have a desktop version for Mac, to use Power BI with Mac the dashboard must be created by a Windows user first.  To do this refer to the below steps to Import your Data Using Power Bi format received from the windows user

...

4.  Enter the following URL to connect to the database https://reports.api.buzsoftwarebuzmanager.com.auImage Removed/reports

Image Added

5. Select Basic -> sign in using your credentials. 

...

8. Once you have the required data from Query Editor → Close & Apply

Image RemovedImage Added

There are three views in Power BI Desktop: Report view, Data view, and Relationships view. 

The following screen shows the three view icons along the left of Power BI Desktop: Report, Data, and Relationships, from top to bottom. The currently displayed view is indicated by the yellow bar along the left. In this case, Report view is currently displayed. You can change views by selecting any of those three icons. 

Image Modified

In Report view the data will populate into a column on the right called fields → Select what data you want to see in the report by selecting or dragging the fields in the order you wish for these to display.

Image RemovedImage Added

Power BI automatically sums the fields with ∑ before the flied name.

Image Added

To remove the sum for this column data under Values → Arrow dropdown → Select Don't summarize

Image Added

Example Report → 

...

1. Open Excel, click on power Query tab
2. Click on "From other sources", select "From OData Feed"
3. Type in your URL → https://reports.api.buzsoftwarebuzmanager.com.au/reports
4. Sign in using your credentials
   1. your user name will have your organizational code (xxxx) forward slash your username for BUZ. Can be found in BUZ under Reports ->  Right hand side ( 5 Character code) or contact BUZ Support to supply your Organizational Code. You will need to receive your organizational code from support to be able to receive your data (Example: MMPCD/support@buzsoftware.com.au)

...