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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.smsagent.blog/microsoft-endpoint-manager-reporting/intune-assignments-report/create-a-powerbi-report.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.