Skip to content

A Walkthrough of BI Pixie Dashboard

After you install BI Pixie Dashboard from Microsoft AppSource and connect it to your BI Pixie storage, as described in Set up BI Pixie Dashboard, you can analyze the usage and engagement of your BI audience. This article describes each of the report pages in BI Pixie Dashboard, one section per page.

For a detailed reference of the metrics in BI Pixie Dashboard, see BI Pixie Metrics.

Main Pages

Summary

The Summary page provides a high-level overview of the tracked Power BI reports, showing key metrics such as the number of tracked reports, users, report sessions, and engagement levels. It includes a breakdown of report activity into Interactive, Passive, and Unused categories, along with user classification (Engaged vs. Passive users). You can filter by date, project/workspace, and report name.

Summary page

Engagement Analysis

The Engagement Analysis page provides a detailed view of user engagement patterns across your reports. It breaks down interactions by type (Visual Interactions, Slicer Clicks, Filter Clicks, Bookmark Clicks, Link Clicks, Tooltip Opens, Drillthroughs) and shows trends over time. On this page, you see which reports and pages drive the most engagement and which types of interactions are most common.

Engagement Analysis page

Producers and Consumers

The Producers and Consumers page is available in the Azure deployment version and requires the integration with Power BI Activity Logs, as described in Deploy BI Pixie on Azure. This page shows both the producers (report creators and editors) and consumers (report viewers) across your Power BI tenant. On this page, you see the ratio between content creators and consumers, track publishing activities, and identify who is creating and consuming content.

Producers and Consumers page

User Adoption

The User Adoption page tracks how users are adopting your Power BI reports over time. It shows new users, returning users, cumulative users, and stickiness metrics (DAU, WAU, MAU, DAU/MAU). On this page, you measure the growth of your BI audience and find trends in user adoption.

User Adoption page

User Attrition

On the User Attrition page, you follow user churn. It shows cumulative lost users, user attrition rate, and identifies users who stopped using your reports. By analyzing attrition patterns, you can take proactive steps to re-engage users and improve report value.

User Attrition page

User Satisfaction

The User Satisfaction page shows feedback collected from your BI audience through the Feedback Controls. To set up feedback collection, see Collect user feedback. It displays CSAT scores, satisfied vs. dissatisfied users, average satisfaction, and feedback trends over time. You can drill down by report to understand which reports are well-received and which need improvement.

User Satisfaction page

Survey Results

The Survey Results page shows the results of embedded surveys. To set up embedded surveys, see Add Embedded Surveys to your Reports. It includes NPS (Net Promoter Score), time savings, financial impact, decision-making impact, and technical issues reported by users. With this page, you quantify the business value of your reports.

Heatmap

The Heatmap page provides a visual representation of user clicks at the visual level within your report pages. Visuals are shown as rectangles with colors ranging from low (cool colors) to high (hot colors) based on the number of clicks. With the Heatmap page, you see which visuals attract the most attention and interaction. To turn on the heatmap, see Analyze engagement at the visual level.

Heatmap page

Custom Visuals Heatmap

The Custom Visuals Heatmap page is available in the Azure deployment version. It shows the distribution and usage of custom visuals across your reports, categorized by their origin: Built-in visuals, Certified custom visuals, Uncertified custom visuals, and Unlisted or Unknown visuals. With the Custom Visuals Heatmap page, you assess the risk and adoption of custom visuals in your organization.

Performance Analysis

The Performance Analysis pages are available in the Azure deployment version and require integration with Azure Log Analytics. To set up performance monitoring, see Analyze Performance. These pages include four tabs: Performance Trends, Performance Heatmap, Performance Impact, and Performance by Users. On these pages, you find slow-loading visuals and high-CPU queries, and correlate performance with engagement.

Performance Analysis page

Data Exports

The Data Exports page is available in the Azure deployment version. It tracks data export activities from your Power BI reports, including exports to Excel, CSV, PDF, and PowerPoint. On this page, you monitor data exports for compliance and security purposes and find which reports and users are exporting the most data.

Data Auditing

The Data Auditing page provides insights into data access patterns. It shows which tables and columns are being accessed through user interactions, so that you can follow data consumption patterns and check data governance compliance.

RLS Auditing

The RLS (Row-Level Security) Auditing page is available in the Azure deployment version. It tracks RLS-related activities. On this page, you can verify that row-level security is properly configured and functioning across your reports. It shows which users are accessing data under which RLS roles.

Design Impact

On the Design Impact page, you analyze the effectiveness of your report design using three scores: Complexity Score, Usability Score, and Passivity Score. These scores are calculated based on the visual elements BI Pixie detects when it adds Pixies (number of visuals, slicers, bookmarks, table visuals, etc.). On this page, you find reports that may need design improvements.

Design Changes

The Design Changes page tracks changes in your report design over time. When you run BI Pixie Desktop (bi-pixie.exe) periodically, it detects changes in the report structure (new pages, added or removed visuals, changed bookmarks, etc.). On this page, you correlate design changes with engagement changes to understand the impact of your report updates.

Business Impact

The Business Impact page is available in the Azure deployment version. It combines data from multiple sources including the Pixies in your reports, Power BI Activity Logs, and Power BI Admin Scan API to give you a view of the business impact of your Power BI reports. It shows endorsement levels and data source analysis. On this page, you see which reports drive the most business value.