Skip to content
BI Pixie Workload in Microsoft Fabric
Generally Available

BI Pixie Dashboard

BI Pixie Dashboard is a Power BI report that BI Pixie installs in your Fabric workspace. After you set up the dashboard, you can use it to analyze how your audience interacts with your Power BI reports. The sections below describe each page in the dashboard and the key visuals on it. For metric definitions, see BI Pixie Metrics.

Note: BI Pixie installs the dashboard in your Fabric workspace when you create the BI Pixie item. See Set up Dashboard for the full walkthrough. The same dashboard is used across the BI Pixie product line, so the visuals, metrics, and layout described here apply identically inside Microsoft Fabric.

Accessing the Dashboard

You can open BI Pixie Dashboard in several ways:

  • From the BI Pixie item's Overview view, with the links in the BI Pixie Dashboard card, which appears once the dashboard is installed.
  • Directly in the Microsoft Fabric workspace where BI Pixie installed it.

Global Filters

The dashboard includes global filters that persist across pages. You can use them to narrow your analysis:

  • Date range: Filter by time period. Defaults to the last 3 years on most pages. Available on every page.
  • Capacity: Filter by Power BI / Fabric capacity (SKU and capacity name).
  • Workspace: Filter by workspace when tracking reports across multiple workspaces.
  • Report: Focus on specific reports.
  • Page: Drill into individual report pages.
  • Platform: Filter by access platform (Desktop, Web, Mobile, Mobile App).
  • User: Drill into individual user behavior.

Overview

Overview is the dashboard's landing page. On it you see a high-level summary of your Power BI portfolio, with key metrics, trends, and a central table for quick comparison across workspaces and reports.

Key visuals:

  • Metric cards: Active users, Reports people interact with, Unused reports, and Satisfaction. Satisfaction is the score from feedback controls.
  • Engagement Funnel: Shows how user activity narrows at each stage of engagement, from broad Report Sessions down to specific Link Clicks: Report Sessions → Page Sessions → Visual Interactions → Slicer Clicks → Bookmark Clicks → Tooltip Opens → Drillthroughs → Link Clicks.
  • Interactive & Passive Sessions over time: Tracks session trends with cumulative user count overlay.
  • Engaged & Passive Users: Column chart comparing active vs. passive user counts.
  • Feedback Clicks: Breakdown of positive, neutral, and negative feedback.
  • Key Survey Results: Financial gains and time savings from embedded surveys.
  • Metrics by Report: A pivot table grouped by workspace and report, with Users, DAU (Daily Active Users), MAU (Monthly Active Users), Passive Users, CSAT, % Unused Pages, % Passive Sessions, Avg Interactions, and Avg Duration per report.

User Adoption

On User Adoption you see how many users actively use your reports over time, with engaged users (who interact with visuals, slicers, and so on) counted apart from passive users (who only view pages).

Key visuals:

  • Metric cards: Active users, DAU, Share who come back daily, and Engaged people.
  • User Adoption Metrics: Line chart showing DAU, DAU (not passive), MAU, and MAU (not passive) across months.
  • Share Who Come Back Daily: Line chart tracking the share of monthly users who come back daily (DAU divided by MAU), with and without passive users. A higher share means users come back more often.
  • MAU (Not Passive): A pivot table showing MAU, excluding passive users, broken down by time calculation (Current, MTD, MOM%, YOY%, and others).
  • Users by Report: Bar chart ranking reports by user count.

User Attrition

On User Attrition you find the users who have stopped engaging with your reports, so you can reach out to them before they drift away. The attrition calculation uses an inactivity window you can change, and by default it ignores the last 2 months.

Key visuals:

  • Metric cards: Active users, Passive people, DAU, and Share who come back daily.
  • User Attrition Metrics over time: Combined chart showing Users, New Users, Last-Time Users (columns) with User Attrition % (line). Last-time users are those whose final activity falls in that month.
  • Inactive Users table: Lists each user with their days of inactivity since last session.
  • Users by Report: Bar chart showing user counts per report with CSAT tooltip.
  • Ignore last N months: A slicer to exclude recent months from the attrition calculation, since those users may still return.

User Engagement Analysis

On User Engagement Analysis you see in detail how users interact with your reports, through distribution histograms, engagement tables, and sub-pages for session-level and low-usage analysis.

Key visuals:

  • Metric cards: Reports opened, Reports people interact with, Passive reports, and Unused reports.
  • Engaged, Passive, New & Last-Time Users: Column chart tracking engaged and passive user trends.
  • Distribution of Avg Interactions by User: Histogram showing how users are distributed by their average interaction count per session.
  • Metrics by Report: Table with Users, MAU, MAU (Exc. Passive), % Unused Pages, % Passive Users, Avg Interactions, Total Interactions, and Avg Duration per report.
  • Metrics by Page: Same metrics at the page level, including % Interactive Sessions and Avg Duration in Page.

The User Engagement Analysis page has three tabbed sub-pages, which are additional pages grouped under the main page's tab. You switch between them with the tab bar at the top:

  • Session Engagement Analysis: Dives deeper into session-level metrics. Shows the Report sessions, Passive sessions, Interactions per session and Average session length cards, the distribution of interactions per session (not per user), Sessions by Report and Sessions by Page tables, and Interactive & Passive Sessions over time.
  • Low-Usage Analysis: Identifies underperforming assets. Shows the Unused reports, Share of opened reports nobody interacted with, Share of pages never opened and Reports with Pixies cards, then Unused Reports, Unused Pages in Active Reports, Least-Active Reports and Pages (below 100 sessions), Least-Active Users, and Inactive Users with days of inactivity.
  • Field Usage: Shows which semantic model fields your report visuals use and which ones people click. Cards count Fields used in visuals, Fields nobody clicked, Columns clicked and Measures clicked. Tables list Fields with no clicks, Most-clicked columns and Most-clicked measures, filtered by workspace, semantic model, report and date.

User Satisfaction

On User Satisfaction you analyze the feedback collected through the feedback controls (thumbs up/down, smile/frown), and see satisfaction trends by report, page, and user. The page fills once feedback collection is turned on, which is available on the Free, Pro, and Enterprise plans.

Key visuals:

  • Satisfaction card: Overall customer satisfaction (CSAT) score. With the CSAT selector, you can switch between "Last Response" (one vote per user-report) and "All Responses" (every click counted).
  • Feedback Clicks by icon: Column chart breaking down clicks by feedback type (positive, neutral, negative).
  • Feedback Clicks by Button: Shows which feedback button style was used (thumbs, smile, etc.).
  • CSAT & Feedback Clicks over time: Combined chart tracking feedback volume and CSAT trend.
  • CSAT by Report: Horizontal bar chart ranking reports by satisfaction score.
  • CSAT by User: Horizontal bar chart showing per-user satisfaction.
  • CSAT & MAU by Report: Scatter plot correlating satisfaction with monthly active users.
  • CSAT & Interactions by Report: Scatter plot correlating satisfaction with average interactions per session.

Survey Results

On Survey Results you see NPS (Net Promoter Score), business value estimates, and time-saved responses from embedded surveys, which are available on the Free, Pro, and Enterprise plans. A "Survey Calc Type" slicer lets you choose between Latest Response (one answer per user-report) and All Responses (every submission counted).

Key visuals:

  • Metric cards: Net Promoter Score (on a -100 to +100 scale), Respondents, Hours saved, and Total gains.
  • NPS over time: Combined chart with Promoters and Detractors (columns) and NPS (line).
  • Responses by Rating: Column chart showing the distribution of NPS ratings (0-10).
  • Time Savings & Financial Gains over time: Column charts tracking the cumulative business impact.
  • Respondents by Financial Gain / Time Saving: Bar charts showing how many respondents selected each answer value.
  • Survey Results by Report: Table with N (respondents), NPS, Detractors, Promoters, Time Savings, Financial Gains, and Gains per Respondent.

The Survey Results page has two tabbed sub-pages:

  • Responses Over Time: Tracks survey responses over time by question, with a question selector slicer. Includes a line chart showing answer distribution, column chart of response counts by answer, and a table of results by report. Also includes an answer slicer to filter to specific responses.
  • Answers by Respondent: Lists individual respondent data (report, date, user, answers, financial gains, time savings, NPS rating) and shows bar charts of respondent distribution by Reported Issues, Time Saving, Decision Impact, and Financial Gain.

Heatmap

On Heatmap you see which visuals receive the most clicks, as a heatmap laid over your report page. See Use Heatmap for setup instructions.

Key visuals:

  • Heatmap grid: A matrix visual that overlays click density on your report page layout. Each cell is color-coded by click count. When you hover over a cell, you see the visual type, title, and click count in a tooltip.
  • Clicks by Page: Table ranking pages by click count, with direct links to open the page in Power BI.
  • Clicks by Visual: Table listing each visual with its ID, type, built-in status, title, and click count.
  • Clicks by Column and Selected Value: Shows what users selected within each visual (slicer values, filter selections, bookmarks, links).
  • Clicks by Event Type: Bar chart breaking down clicks by interaction type (VizClick, Slicer, Bookmark, Link).
  • Clicks by Visual Type: Bar chart showing which visual types receive the most clicks.

Custom Visuals Heatmap

Custom Visuals Heatmap extends the heatmap with a focus on the security and trust of custom visuals. On it you see which custom visuals your reports use and their certification status (Certified, Not Certified, Unlisted, Unknown), mapped on the page layout and colored by trust level.

Key visuals:

  • Custom Visuals Heatmap grid: A matrix overlaying visual trust levels on your page layout. Colors indicate certification status.
  • Visuals by State: Table listing visual states (Certified, Not Certified, Unlisted, Unknown) with trust levels and visual counts.
  • Count of Custom Visuals by Type: Table showing visual type, certification state, publisher, visual count, and click count.
  • Pages with Custom Visuals: Table listing pages with counts of Certified, Uncertified, and Risky visuals.
  • Clicks by Visual: Detail table listing each visual with its type, trust state, ID, and title.

Data Auditing - Analysis

On Data Auditing - Analysis you audit data access: which data values users select through slicers, filters, and visual interactions. You can spot potential data governance concerns and see which data dimensions and values are accessed most often.

Key visuals:

  • Data Selections Over Time: Line chart tracking the volume of data selection events.
  • Decomposition Tree: Interactive drill-down from Filtered Table → Filtered Column → Filtered Values, showing how many times each data path was accessed.
  • Word Cloud: Visual summary of the most frequently selected data values.
  • Data Selections by User: Tables showing which users accessed which data values, on which reports and pages.
  • Slicers: Filter by Filtered Table, Filtered Column, Filtered Values, and Distinct Count to narrow the audit.

The Data Auditing - Analysis page has one tabbed sub-page:

  • Data Auditing - Details: Lists every data selection in a table, with the user, date, report, table, column, selected values, and views or clicks, alongside the same slicers and word cloud.

RLS Auditing

On RLS Auditing you see the Row-Level Security (RLS) context of the users interacting with your reports, so you can detect RLS misconfigurations, overexposed data, and potential security risks. The page fills once RLS auditing is turned on in Tracking Setup.

Key visuals:

  • Metric cards: Users with suspicious changes, Suspected overexposed rows, Over-blocked users, and Users with no single role.
  • RLS Alert Metrics by Report: Table showing per-report breakdown of users with single roles, unmatched/multiple roles, over-blocked users, suspicious changes, and overexposed rows.
  • RLS Alert Metrics by User: Same metrics at the user level.
  • RLS Alert Metrics by Date: Combined chart tracking Views with No Single Role, Over-Blocking Views, and Suspected Overexposed Rows over time.
  • Overexposed Data: Table showing RLS role, secured table, suspected overexposed rows, expected row count, and actual loaded rows.
  • Maximal Distinct Count of Filtered Values: Table showing the maximum number of distinct values each user sees through each RLS role and column.
  • Distinct Count of Filtered Values by Table: 100% stacked bar chart showing how filtered values are distributed across RLS roles and tables.

The RLS Auditing page has one tabbed sub-page:

  • RLS Suspicious Changes: Focuses on detecting suspicious changes in RLS-filtered data. Shows a decomposition tree for drilling into changes by Report → RLS Role → User → Secured Table → Column → Filtered Values, plus bar charts of RLS Changes by User and by Report, a timeline of changes, and tables showing actual rows loaded and accessible data by filter value.

Design Impact

On Design Impact you analyze how report design affects user engagement. BI Pixie calculates three scores per report: Complexity Score (based on visual count and layout density), Usability Score (based on interactive controls like bookmarks, slicers, tooltips, and drill-throughs), and Passivity Score (based on the ratio of table visuals and columns to total visuals), and you compare those scores with business outcome metrics (MAU, Interactive Sessions, CSAT, NPS, Financial Gains, Time Savings).

Key visuals:

  • Scatter plots: Plot reports by a design attribute (X axis) against a business outcome (Y axis), with bubble size indicating user count. With the two slicers, you choose which design attribute and which business outcome metric to compare.
  • Design Metrics by Report: Table listing each report with Users, MAU, Complexity/Usability/Passivity scores, Pages, Visuals per Page, Tables/Matrices, Columns in Tables, Bookmarks, Slicers, Tooltip Pages, Drillthrough Pages, and non-analytic objects (buttons/shapes/images).

The Design Impact page has two tabbed sub-pages:

  • Design Impact by Page: Same scatter plots and design metrics but at the page level instead of report level.
  • Design Changes: Tracks how design metrics change over time. Shows a line chart correlating a design metric (e.g., Visuals per Page) with a business outcome (e.g., MAU) over time. Includes a detailed table of design metrics by page.

A help tooltip, Design Impact Help, explains how to interpret the design scores.

Position of Pages

On Position of Pages you analyze how the position (index) of a page within a report affects engagement, so you can decide which pages to place first and whether reordering could improve usage.

Key visuals:

  • Active & Passive Users by Page Position: Column chart showing engaged vs. passive users at each page index.
  • Average Interactions & Duration per Session: Combined chart showing average interactions (columns) and average time spent (line) at each page position.
  • Activity Metrics by Position of Page: 100% stacked column chart breaking down all activity types (Report Sessions, Page Sessions, Visual Interactions, Slicer Clicks, Bookmark Clicks, Tooltip Opens, Drillthroughs, Link Clicks) by page position.
  • Pages by Interactions & Duration: Scatter plot showing each page positioned by its average page index (X), average interactions (Y), with bubble size indicating time spent.

Activity by Report

On Activity by Report you see individual event types broken down by different dimensions. An activity metrics slicer lets you choose which activities to display as a dynamic field parameter.

Key visuals:

  • Metric cards: Page sessions, Visual interactions, Slicer clicks, and Drillthroughs.
  • Page Activities Over Time: Combined chart showing each activity type as a separate series.
  • Tracked Activities by Report: 100% stacked bar chart showing the activity mix per report.
  • Sessions by Report: Table with Sessions, Interactions per Session, % Interactive Sessions, Passive Sessions, and CSAT per report.

The Activity by Report page has three tabbed sub-pages:

  • Activity by User: Same activity breakdown but grouped by user. Includes a users table with Sessions, Interactions per Session, % Interactive Sessions, and CSAT.
  • Activity by Page: Same activity breakdown but grouped by page. Includes a page sessions table with Avg Interactions, % Interactive Sessions, and Passive Sessions.
  • Single User Activity: Deep dive into a single user's event timeline. Shows a word cloud of their most-accessed data values, an event log table (timestamp, report, page, event type, platform, visual details, bookmarks, links, filters, IP), and tracked activities over time.

Metrics by Report

Metrics by Report combines every metric into a single table, for detailed comparison and export. It has field parameter slicers for User Adoption Metrics, Report Session Metrics, Activity Metrics, and a Time Intelligence slicer (Current, MTD, MOM%, YOY%, running averages, etc.).

Key visuals:

  • Master table: A comprehensive table with columns for Project, Capacity, Workspace, Report, CSAT (Last Response and All Responses), NPS, all User Adoption Metrics (Users, Engaged, Passive, DAU, MAU, WAU and their ratios), all Report Session Metrics (Sessions, Interactive/Passive, Duration, Interactions, Total Hours), and all Activity Metrics (Page Views, Visual Interactions, Slicer Clicks, Bookmarks, Tooltips, Drillthroughs, Link Clicks).

The Metrics by Report page has two tabbed sub-pages:

  • Metrics by User: The same comprehensive metric table, but with an additional User column, showing all metrics per user per report. Includes separate tables for report-level and page-level engagement, with page session metric slicers.
  • All Metrics: A reference page showing all available metrics organized by category (Report Metrics, Report Sessions, Adoption Metrics including/excluding Passive, Page Metrics, Page Sessions, Tracked Activities, User Satisfaction, Survey Analysis, Design Scores) with a Time Intelligence slicer.

Events

Events is a raw log of individual telemetry records. You can use it for debugging, auditing, or understanding specific user interactions at the lowest level of detail.

Key visuals:

  • Recent events table: Shows each event with timestamp, project, workspace, report, page, event type, page index, username, platform, visual name, visual type, bookmark, feedback, link, filtered column, filtered values, and a masked client IP that does not reveal the viewer's IP address.
  • Event Type slicer: Filter events by type: Bookmark, Drillthru, Feedback, Filter, Link, Page, RLS, Sense, Slicer, Tooltip, or VizClick.

BI Pixie collects viewer user names only when you turn on Capture user identity in Tracking Setup. You then choose on the Security tab of the Account page whether BI Pixie keeps the email address, a masked ID, or nothing. Until then, BI Pixie counts viewers by a masked IP address.

Related Resources

  • Tracking Setup: Configure tracking options, feedback controls, and surveys that feed into the dashboard.
  • Set up Dashboard: Load your engagement data into the dashboard.
  • BI Pixie Semantic Model: Understand the semantic model behind the dashboard, for building custom reports.

What's Next