# Insight report

## Introduction

This guide provides detailed instructions for configuring and deploying the Power BI Insight Report. It covers obtaining the report, setting up necessary parameters, publishing to a workspace, and configuring the report on the portal.

## Obtaining the Power BI report

1. Download the Power BI report by [clicking here](https://pltstorage.blob.core.windows.net/pltblob/LoadFAST_Insight_Report.pbix).
2. Open the downloaded file using Power BI Desktop application.
3. If Power BI Desktop is not installed on your system, you can download it from the [official Microsoft download page](https://www.microsoft.com/en-us/power-platform/products/power-bi/downloads?msockid=2d9f8972b1216ccc24169ddbb0ba6d71).

## Report features

The Power BI Insight Report offers comprehensive analytics on test performance and collection metrics, including:

* Test status breakdown showing passed, failed, and partially passed tests within collections
* Collection composition metrics displaying the number of reports and pages
* Performance analysis identifying the most expensive visual with corresponding test run, report, and page details
* Detailed load time metrics at multiple levels:
  * Report level performance metrics
  * Page level load times
  * Visual level response times
  * User action performance measurements

## Configuration process

### Setting up parameters:

1. Access parameter settings by clicking on **Transform Data** in the Power BI desktop interface.

<figure><img src="https://2147433183-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3Am7TO0x29a6l1P0wMUg%2Fuploads%2F0fDlxp0KkKgeUtlhPA41%2Fimage001.png?alt=media&#x26;token=8826262d-be82-4213-a965-62ae0e9de682" alt=""><figcaption></figcaption></figure>

2. Click on **Manage Parameters.**

<figure><img src="https://2147433183-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3Am7TO0x29a6l1P0wMUg%2Fuploads%2F6g5pHpbyOw068MJjGsp1%2Fimage003.png?alt=media&#x26;token=679b5f1f-6e00-4495-82ad-4844c8beb48b" alt=""><figcaption></figcaption></figure>

3. Update values for each parameter and confirm by clicking the **OK** button.
   * RangeStart: Enter the date of installation
   * RangeEnd: Enter the date of installation plus one day
   * ServerName: Use the server name provided during installation
   * DatabaseName: Use the database name provided during installation

<figure><img src="https://2147433183-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3Am7TO0x29a6l1P0wMUg%2Fuploads%2FikzMj7ZNBswYJOz4Pmtq%2Fimage005.png?alt=media&#x26;token=323705b6-2404-406e-8570-1384ceee49e9" alt=""><figcaption></figcaption></figure>

4. Click on the Refresh Preview to check if data is loading after updating the parameters.

<figure><img src="https://2147433183-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3Am7TO0x29a6l1P0wMUg%2Fuploads%2FYrrfRAiKEvm0wCUMfncI%2Fimage007.png?alt=media&#x26;token=f1f5a0cd-9e08-47c0-a78f-61f1b8b1730e" alt=""><figcaption></figcaption></figure>

### Troubleshooting firewall errors

If you encounter a firewall error after refreshing the preview, follow these steps:

1. You may get an error like this after the refresh.

<figure><img src="https://2147433183-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3Am7TO0x29a6l1P0wMUg%2Fuploads%2FvqIK1tWyHIeEyTG1nJEz%2Fimage009.png?alt=media&#x26;token=35d7a98a-e14d-459b-a058-9d04ffe673b4" alt=""><figcaption></figcaption></figure>

2. Navigate to **portal.azure.com** and search for your SQL DB.

<figure><img src="https://2147433183-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3Am7TO0x29a6l1P0wMUg%2Fuploads%2F8lMPY8J3VsM6VeReMr2s%2Fimage011.png?alt=media&#x26;token=223804df-ff2a-49f1-935e-f0d94a83232a" alt=""><figcaption></figcaption></figure>

3. Go to the SQL DB and click on the **Set Server Firewall.**

<figure><img src="https://2147433183-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3Am7TO0x29a6l1P0wMUg%2Fuploads%2FZPR2UOg6IXXiL8AxcH0Y%2Fimage013.png?alt=media&#x26;token=8773e22e-46ff-445f-90bc-f3bd8734d2ea" alt=""><figcaption></figcaption></figure>

4. Click on **Add your Client IPv4 address** and paste the IP address you received in the error message and click **Save**.

<figure><img src="https://2147433183-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3Am7TO0x29a6l1P0wMUg%2Fuploads%2FFbUcbJI5LX3lVdMumN6p%2Fimage015.png?alt=media&#x26;token=6662621f-2181-4351-b7d8-132694426429" alt=""><figcaption></figcaption></figure>

5. Return to Power BI Desktop and click on the **Refresh Preview** to get the updated data.

<figure><img src="https://2147433183-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3Am7TO0x29a6l1P0wMUg%2Fuploads%2FOb3zalmJKWzuw3A6dM84%2Fimage017.png?alt=media&#x26;token=44f7ff60-d6c6-429d-aa7d-4cc8ae4e7580" alt=""><figcaption></figcaption></figure>

6. Apply your changes by selecting **Close and Apply**.

<figure><img src="https://2147433183-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3Am7TO0x29a6l1P0wMUg%2Fuploads%2FXvDUcCW4atIVidglgrOt%2Fimage019.png?alt=media&#x26;token=4c87b796-43c1-4241-b649-cc26058b1ed1" alt=""><figcaption></figcaption></figure>

### Publishing the report

After configuring parameters:

1. Click the **Publish** button in the Power BI desktop ribbon.

<figure><img src="https://2147433183-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3Am7TO0x29a6l1P0wMUg%2Fuploads%2FGriUjnATAtwLSuepiclW%2Fimage021.png?alt=media&#x26;token=9f65c3ee-639d-4faf-8123-119b6392b8b5" alt=""><figcaption></figcaption></figure>

2. From the dialog that appears, select your target workspace.

<figure><img src="https://2147433183-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3Am7TO0x29a6l1P0wMUg%2Fuploads%2FG8QGwMo1LLoPGb5O3Muc%2Fimage022.png?alt=media&#x26;token=f9a16d08-659a-4966-9535-902724985916" alt=""><figcaption></figcaption></figure>

3. Navigate to app.powerbi.com and access the semantic model of your published report.

<figure><img src="https://2147433183-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3Am7TO0x29a6l1P0wMUg%2Fuploads%2Fd4ph2VPjM53iHO4ZxtLr%2Fimage024.png?alt=media&#x26;token=4d2f84c1-0653-48ec-92ce-41e315d970f2" alt=""><figcaption></figcaption></figure>

### Configuring the insight report on the portal

To access insight report on the portal:

1. Navigate to **Admin Settings** and open the **Insights Report** section.

<figure><img src="https://2147433183-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3Am7TO0x29a6l1P0wMUg%2Fuploads%2FqjHNmpd5ff8QeLnJ5Dp7%2Fimage024.png?alt=media&#x26;token=ddac7b07-97f2-449d-b75c-4d718670ebfd" alt=""><figcaption></figcaption></figure>

2. Obtain the required identifiers from Power BI service:

* **Workspace ID**: Located in the URL after "groups/"

<figure><img src="https://2147433183-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3Am7TO0x29a6l1P0wMUg%2Fuploads%2Fwl0WX9zDq3pa1rGKAqhZ%2Fimage026.png?alt=media&#x26;token=008c97b5-1aeb-4897-be5a-aec17faeb2bb" alt=""><figcaption></figcaption></figure>

* **Report ID**: Located in the URL after "reports/"

<figure><img src="https://2147433183-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3Am7TO0x29a6l1P0wMUg%2Fuploads%2FC2PeEaOWml8eWBZ9Nz7f%2Fimage028.png?alt=media&#x26;token=778c0ebe-0086-444d-9d26-cc4472bcea65" alt=""><figcaption></figcaption></figure>

* **Dataset ID**: Access the semantic model used by the report and extract the ID from the URL after "datasets/"

<figure><img src="https://2147433183-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3Am7TO0x29a6l1P0wMUg%2Fuploads%2FWeFYhM0zX7GFBT5RgPeR%2Fimage030.png?alt=media&#x26;token=b9ef0445-f847-4216-b006-985988b041ef" alt=""><figcaption></figcaption></figure>

3. Enter these identifiers in their respective fields on the portal configuration page.
4. Click **Apply** to save your configuration.

<figure><img src="https://2147433183-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3Am7TO0x29a6l1P0wMUg%2Fuploads%2FAUTgTJ6BbnuCwR0cBp0j%2Fimage032.png?alt=media&#x26;token=0174fbce-f70b-489e-920c-e0392d9cc83f" alt=""><figcaption></figcaption></figure>

5. Access your report by clicking on **Insights Report** in the navigation menu.

<figure><img src="https://2147433183-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3Am7TO0x29a6l1P0wMUg%2Fuploads%2FTEc4C4bYmq0MOCVb2ETd%2Fimage034.png?alt=media&#x26;token=b4314293-6af8-4e8a-838a-587d46ea1902" alt=""><figcaption></figcaption></figure>
