Analyze Performance

Measuring the effectiveness of your Power BI reports is not complete without taking performance into account. BI Pixie can combine engagement data with performance metrics from Azure Log Analytics to give you a comprehensive view of your report quality.

Prerequisites

Performance analysis requires that your Power BI workspaces are integrated with Azure Log Analytics. This is a Microsoft feature that sends detailed performance data (query durations, rendering times, and other report telemetry) to a Log Analytics workspace in your Azure tenant.

Learn how to integrate Power BI with Azure Log Analytics from Microsoft documentation.
You will need the Workspace ID of your Azure Log Analytics workspace.

Enable Performance Analysis

In the BI Pixie item, open the Tracking Setup view from the sidebar.
In the left hierarchy panel, select Account Defaults for account-level defaults, or select a specific workspace to configure performance analysis at the workspace level.
Find the Performance Analysis section.
Toggle Enable Performance Analysis on.
Enter your Azure Log Analytics Workspace ID.
Click Save settings and confirm the save dialog.
Open the Add Pixies tab and add Pixies to apply the changes.

Note: Settings in BI Pixie follow a three-level hierarchy. Account defaults apply to all reports. You can override them at the workspace level or the report level. See Settings for details.

Screenshot: Performance Analysis section in the Tracking Setup view of the BI Pixie item, showing the toggle and the Azure Log Analytics Workspace ID field.

What You Can Analyze

With performance data connected, BI Pixie Dashboard provides the following insights:

Report rendering times — How long it takes for reports to load and render for your users.
Query performance — DAX query execution times and their impact on user experience.
Performance trends — Track how performance changes over time as reports evolve.
Performance vs. engagement correlation — Understand whether slow reports lead to lower engagement, helping you prioritize the reports that need optimization the most.

These insights are available in the Performance Analysis page of BI Pixie Dashboard.

Screenshot: Performance Analysis page in BI Pixie Dashboard, showing rendering times, query durations, and engagement correlation across reports.

Identifying Slow Reports

Use the Performance Analysis page to spot the reports that need optimization:

Sort reports by average rendering time to find the slowest experiences.
Cross-reference rendering time with session counts — a slow report with heavy traffic is a higher priority than a slow report few people use.
Look for reports where engagement drops as rendering time grows; these are strong candidates for tuning the semantic model, simplifying visuals, or splitting pages.

Related Resources

Settings — Configure performance analysis and other tracking options.
Set up BI Pixie Dashboard — Install the Power BI app to view performance analytics.

What's Next

BI Pixie Dashboard — Explore all dashboard pages, including Performance Analysis.
Use Heatmap — Combine performance with click-level interaction data.