---
title: "Configure Sitecore Power BI health reports"
slug: "configure-sitecore-power-bi-health-reports"
abstract: "Use Power BI to view the enhanced health metrics of your Sitecore solution running on Azure."
---
# Configure Sitecore Power BI health reports

You can use the Power BI Health Reports template with the Sitecore solutions that use the Sitecore Azure Toolkit. The health reports provide summaries of the metrics for your Sitecore solution, including:

- Interactions and errors when aggregating interactions
- Contacts processed and errors when processing contacts
- Requests by type
- Cache hits and misses

<details>
<summary><h2>Prerequisites</h2></summary>

Before you can use the Sitecore Power BI Heath Reports template and configure the reports to extract information from your Azure subscription, you must have the following:

- The [Microsoft Power BI Desktop app](https://powerbi.microsoft.com/en-us/desktop/).
- The `Sitecore Power BI Health Reports.pbit` file (available from [dev.sitecore.net](https://dev.sitecore.net/Downloads/Sitecore_Azure_Toolkit/))
- A Sitecore installation running on the Microsoft Azure subscription

</details>

<details>
<summary><h2>Connect the template file to Azure Application Insights</h2></summary>

To view the metrics in your Power BI health reports, you must connect your `Sitecore Power BI Health Reports.pbit` file to the Microsoft Power BI desktop application.

To connect the template file to your Azure Application Insights:

1. In the **PowerBI** application, to open the `Sitecore Power BI Health Reports.pbit` file, double-click the file or click **File open**.

    ![8117917C4BA5425E8ADD73F2718B14ED.png](https://doc.sitecore.com/api/markdown-image/xp/en/developers/103/sitecore-experience-manager/images/8117917C4BA5425E8ADD73F2718B14ED.png)

    Power BI requests the application ID (AppId) of the Azure Application Insights that you want to report on.

2. To locate the Application ID, log in to the Azure portal and select the relevant subscription.
3. Open the **Application Insights** instance.
4. In the menu, under **Configure**, expand the **API Access** tab.
5. To copy the Application ID, click the blue icon ![781366092F034C5BB24C4232F94361F7.png](https://doc.sitecore.com/api/markdown-image/xp/en/developers/103/sitecore-experience-manager/images/781366092F034C5BB24C4232F94361F7.png) to the right of the **Application ID** field.

    ![E8CBBA328FDD4C5283AB2A2BD2524FF1.png](https://doc.sitecore.com/api/markdown-image/xp/en/developers/103/sitecore-experience-manager/images/E8CBBA328FDD4C5283AB2A2BD2524FF1.png)

6. In Power BI, paste the Application ID into the **AppId** field, and click **Load**.

    ![EB1C49F556C64FB9B06DD6E135EAEBC8.png](https://doc.sitecore.com/api/markdown-image/xp/en/developers/103/sitecore-experience-manager/images/EB1C49F556C64FB9B06DD6E135EAEBC8.png)

7. Power BI prompts you for authentication. The default authentication is Anonymous, however, you must change it to Basic.

    ![0FB05AB0760E4125B8D68E19606F97FF.png](https://doc.sitecore.com/api/markdown-image/xp/en/developers/103/sitecore-experience-manager/images/0FB05AB0760E4125B8D68E19606F97FF.png)

</details>

<details>
<summary><h2>Generate a password using the Azure portal</h2></summary>

Next, you must generate the password using the Azure portal:

1. Log in to the Azure portal.
2. Select the relevant subscription.
3. Open the **Application Insights** instance.
4. In the menu, under **Configure**, expand the **API Access** tab.
5. Click **Create API key**.

    ![5421C146BE794C9A9A7062EEE6A9439F.png](https://doc.sitecore.com/api/markdown-image/xp/en/developers/103/sitecore-experience-manager/images/5421C146BE794C9A9A7062EEE6A9439F.png)

6. Enter a name for the key and select the **Read telemetry** and **Authenticate SDK control channel** check boxes.

    ![6D20ECCD2EBF4BF9831F262B614408FA.png](https://doc.sitecore.com/api/markdown-image/xp/en/developers/103/sitecore-experience-manager/images/6D20ECCD2EBF4BF9831F262B614408FA.png)

7. Click **Generate Key**. Azure assigns a key for you to use as a password in the **Basic** authentication dialog box.
8. To copy the key, click the blue icon to the right of the **Key** field.

    ![965E59F046914613A614EF446A7805D1.png](https://doc.sitecore.com/api/markdown-image/xp/en/developers/103/sitecore-experience-manager/images/965E59F046914613A614EF446A7805D1.png)

    > [!note]
    > Microsoft does not store the key; therefore, it is a good idea to paste the key into a text file so that you have access to it later.

9. In the **Access Web content** dialog box, paste the key into the **Password** field and click **Connect**.

    ![4DFFAA20FC6F4268830B1184AE8762E0.png](https://doc.sitecore.com/api/markdown-image/xp/en/developers/103/sitecore-experience-manager/images/4DFFAA20FC6F4268830B1184AE8762E0.png)

</details>

<details>
<summary><h2>View the health reports</h2></summary>

To view the metrics of your Sitecore installation:

- In your Power BI desktop, click the tabs at the bottom of the page to access the following Power BI health reports:
    - Interactions
    - Contacts
    - Requests
    - Aggregated Cache Hits/Misses
    - Data Cache Hits/Misses
    - Geo IP Reads/Cache Hits
    - Locations

![5E9AE304433A4C6AABDD649935C711D4.png](https://doc.sitecore.com/api/markdown-image/xp/en/developers/103/sitecore-experience-manager/images/5E9AE304433A4C6AABDD649935C711D4.png)

</details>