Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Before you can start using Power BI with BUZ you will need to contact BUZ Support to get a link and your Organizational Code. See /wiki/spaces/PROC/pages/4325394Connect to your Data

Close the popup screen (select the x in the top right corner of popup), the Report view of Power BI Desktop is displayed close that too.

...

5.  Import Excel data into Power Bi

Connect to your Data

Anchor
Connect to your Data
Connect to your Data

  1. Open Power BI data link (supplied by BUZ Support currently in drop box or via email)
  2. Click on "Basic"
  3. Sign in using your credentials 
    1. Your user name will have your organizational code (e.g. MMPCD) forward slash your username for BUZ which should be your email address. 
    2. You will need to receive your organizational code from support to be able to receive your data (Example: MMPCD/support@buzsoftware.com.au).
    3. Password is your normal BUZ password.


  4. There are three views in Power BI Desktop: Report view, Data view, and Relationships view. Power BI Desktop also includes Query Editor, which opens in a separate window. In Query Editor, you can build queries and transform data, then load that refined data model into Power BI Desktop, and create reports.

     

    The following screen shows the three view icons along the left of Power BI Desktop: ReportData, 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. 


    With Power BI Desktop installed you’re ready to connect to data, shape data, and build reports (usually in that order). 

...