Create the Power BI report

Here we will create a Power BI report from the template

Download

Download the Power BI template for the Overview report here.

Download the Power BI template for the Detailed report here.

Configure the datasource

• Open the Power BI template with Power BI desktop

• Upon opening, you will be prompted for the storage account name and the container name

• Enter the name of the Azure storage account where you are saving the CSV exports

  • Make sure there are no spaces surrounding the storage account name

• Enter the name of the container in the Azure storage account where the CSV files are exported to

• Click Load

• If this is the first time you are connecting to the storage account with Power BI, you will be prompted for the Account key. Retrieve this from the storage account under Access Keys.

Your data will then be imported into the report.

If you regenerate your storage account keys, you will need to update your Power BI report.

Publish the report

Once your report has been created, you can publish it to the Power BI 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 and don't configure the report to refresh at the same time - try 30 minutes later for example. There is no need to use a data gateway as the storage account data source is also a cloud service.

When publishing the report to the Power BI service, for better security you may wish to configure a service principal to connect to the Azure storage account rather than using the account key.