# Create a PowerBI report

## Connect to Azure Blob storage

* Open **PowerBI desktop** and choose **Get Data**
* In the **Azure** section, choose **Azure Blob Storage**

![](https://3886807721-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MWe9ieepRHnj7T8odXt%2F-M_RvziJmG2w3VdEaGV-%2F-M_SJj_fyEJnfeLwO7oI%2Fimage.png?alt=media\&token=c2c858e4-d758-4e8d-9190-ac1228e32fd9)

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

![](https://3886807721-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MWe9ieepRHnj7T8odXt%2F-M_RvziJmG2w3VdEaGV-%2F-M_SJwFkXBj3NYEEvZkw%2Fimage.png?alt=media\&token=220aaee1-f635-4ba4-b922-3a8b85231f23)

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

![](https://3886807721-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MWe9ieepRHnj7T8odXt%2F-M_RvziJmG2w3VdEaGV-%2F-M_SKTX2L8Ge0L5zOxsw%2Fimage.png?alt=media\&token=a86eb75a-ae6b-4cfa-9784-4c875c02c54e)

{% hint style="warning" %}
If you regenerate your storage account keys, you will need to update your PowerBI report
{% endhint %}

* 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**

![](https://3886807721-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MWe9ieepRHnj7T8odXt%2F-M_RvziJmG2w3VdEaGV-%2F-M_SMDtJzi_rK6SIOpwo%2Fimage.png?alt=media\&token=9e8dd7aa-a768-4c0f-a047-aae3396af286)

* 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.

![](https://3886807721-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MWe9ieepRHnj7T8odXt%2F-M_RvziJmG2w3VdEaGV-%2F-M_SMvACxpMN-mhSinui%2Fimage.png?alt=media\&token=46991efe-483e-4a97-afed-d75ff9242a32)

![](https://3886807721-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MWe9ieepRHnj7T8odXt%2F-M_RvziJmG2w3VdEaGV-%2F-M_SNkefIEQCGuVHALNy%2Fimage.png?alt=media\&token=4d47ae08-f6bb-48ad-9079-1d5102b17ea7)

* 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:

![](https://3886807721-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MWe9ieepRHnj7T8odXt%2F-M_RvziJmG2w3VdEaGV-%2F-M_SPJ6_G917MeqYEluX%2Fimage.png?alt=media\&token=d337ee5f-1f15-4cdb-9f18-e6287e3b5eb2)

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

![](https://3886807721-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MWe9ieepRHnj7T8odXt%2F-M_RvziJmG2w3VdEaGV-%2F-M_SQ5CTAog9jmi-cp1W%2Fimage.png?alt=media\&token=4d81d77a-fcae-45af-af9a-3fcc1de1d71a)

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

![](https://3886807721-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MWe9ieepRHnj7T8odXt%2F-M_RvziJmG2w3VdEaGV-%2F-M_SS7g9iGzSoZSQrgXr%2Fimage.png?alt=media\&token=2a5297f5-282a-45c6-9374-7c08012cc464)

## 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.