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.

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.

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.

1. Click on Manage Parameters.

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

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

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.

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

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

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

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

1. Apply your changes by selecting Close and Apply.

Publishing the report

After configuring parameters:

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

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

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.

1. Obtain the required identifiers from Power BI service:

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

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

1. Enter these identifiers in their respective fields on the portal configuration page.

2. Click Apply to save your configuration.

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