Microsoft Power BI - Getting Started

Sam Kirbow

October 07, 2020 21:27

Power BI:

Once users have installed Power BI Desktop, they can pull in their company data to generate visual reports and dashboards. The Power BI dataset and reports can then be published to the Power BI Cloud platform so they can be shared inside your organization.

Installation:

The following steps outline how to get all of the required components so that you can start designing reports:

Download and Install Microsoft Power BI Desktop
Download the BrightMove Power BI Data Model (PBIX File)

Configuration:

Open Microsoft Power BI
Choose File -> Open from the Menu, and then select the Brightmove.pbix file downloaded in Step 2 above.
The built-in reports will show with no data to report on. This is normal until we configure your credentials to pull your data.
The next step is to tell Power BI your BrightMove credentials so your data can be retrieved
Click Refresh in the top menu
Click Basic
Enter your BrightMove username and password. (These are the same credentials you use when accessing BrightMove from your browser.)
Select the bottom URL radio button (https://analytics-v1.brightmove.com/BrightMove.svc) then click Connect

Depending on the amount of data you have in BrightMove, this process can take anywhere from 1 minute to 1 hour.
The progress will look similar to this dialog. Once all of your data has been downloaded, this dialog will disappear and you should see data in your default report tabs
Here is what your default report might look like once the data has been download.