Create a PowerBI report

Here we will look at how to connect PowerBI to our storage account and import our data

Connect to Azure Blob storage

  • Open PowerBI desktop and choose Get Data

  • In the Azure section, choose Azure Blob Storage

  • In the next window, enter the Account name of the storage account

  • Next you will be prompted for the Account key. You'll find this in the storage account under Access Keys.

If you regenerate your storage account keys, you will need to update your PowerBI report

  • Click Connect

  • In the Navigator window, select the container that holds the exported CSV files. You'll see the files in the container on the right

  • Click Transform Data

  • In the Power Query Editor window, you'll see the 3 files listed. Rename the query for one of the files, for example Android_Devices, then click on the Binary link in the Content column for the AndroidDevices.csv. This will transform the data from the CSV file into the query.

  • Staying in the Query Editor, right-click the blank space on the left under Queries [1], choose New Query > Recent sources, and select the storage account source you just used. This will bring up the Navigator window again. Repeat the above steps, selecting the container and transforming the content until you have all 3 queries added:

  • Finally, in the Home menu, click Close and Apply. The data will then be imported from the CSV files into the report.

From here, you can build out your report as you wish.

Publish the report

Once your report has been created, you can publish it to the PowerBI service by clicking Publish on the Home menu.

Once published, you can schedule the data to refresh periodically to keep the report up to date. Do not refresh more frequently than the schedule of your automation runbook. You do not need to use a data gateway as the storage account datasource is also a cloud service.

Last updated