Skip to main content

Configure Sitecore Power BI health reports

Abstract

Use Power BI to view the enhanced health metrics of your Sitecore solution running on Azure.

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

Prerequisites

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:

Connect the template file to Azure Application Insights

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

    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 to the right of the Application ID field.

    E8CBBA328FDD4C5283AB2A2BD2524FF1.png

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

    EB1C49F556C64FB9B06DD6E135EAEBC8.png

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

    0FB05AB0760E4125B8D68E19606F97FF.png

Generate a password using the Azure portal

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

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

    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

    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

View the health reports

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