> For the complete documentation index, see [llms.txt](https://docs.smsagent.blog/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.smsagent.blog/microsoft-endpoint-manager-reporting/intune-assignments-report/create-a-powerbi-report.md).

# Create a Power BI report

{% hint style="info" %}
Make sure you have run the automation runbook at least once to export some data before configuring the Power BI report.
{% endhint %}

## Download the Power BI template

Download the Power BI template from here: <https://github.com/SMSAgentSoftware/IntuneAssignmentsReport>

## Connect to Azure Blob storage

* Open the template in Power BI desktop.&#x20;
* When you do, you'll be prompted for the S**torage account name** and the **Container name**. Enter the values from the storage account you created.

<figure><img src="/files/O54t7eTu22gZBIVOFX2o" alt=""><figcaption></figcaption></figure>

* If this is the first time you are connecting Power BI to the storage account, you may be prompted for the **Account key.** You'll find this in the storage account under **Access Keys**.

![](/files/-M_SKTX2L8Ge0L5zOxsw)

{% hint style="warning" %}
If you regenerate your storage account keys, you will need to update your Power BI report. For greater security, consider using a Service Principal instead when you publish your report.
{% endhint %}

* Click **Connect**
* Your report data should now load in.

## 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. You do not need to use a data gateway because the storage account data source is also a cloud service.