Excessive Visuals
Detects report pages with too many visuals, causing slow rendering and high query volume.
What It Detects
This flag identifies report pages that contain more visuals than the recommended threshold. Each visual on a page generates one or more DAX queries when the page loads, so a high visual count directly correlates with slow page load times and high CU consumption.
Why It Matters
- Slow page load — Each visual fires at least one query. A page with 30 visuals fires 30+ queries simultaneously, overwhelming the dataset engine.
- High CU burst — All queries for a page are submitted concurrently, creating a CU spike that can trigger throttling on shared capacities.
- Poor user experience — Users see a cascade of loading spinners, partial data, and layout shifts as visuals render at different speeds.
- Browser memory pressure — The Power BI web renderer must maintain the DOM for every visual, which can cause tab crashes on lower-end devices.
Trigger Conditions
A report page is flagged when:
- The total number of visuals on the page exceeds 20 visuals (configurable threshold).
This count includes all visual types: charts, tables, matrices, cards, KPIs, slicers, and data-bound shapes.
Threshold: > 20 visuals per page (default).
Output
| Field | Description |
|---|---|
reportName | Report name |
pageName | Page name or display name |
visualCount | Total number of visuals on the page |
dataVisualCount | Number of data-bound visuals (charts, tables, cards) |
slicerCount | Number of slicers |
workspaceName | Workspace name |
Notes and Edge Cases
- Hidden pages — Hidden or tooltip pages are included in the scan. If a tooltip page has many visuals, it is flagged but may be less impactful because it is only rendered on hover.
- Bookmarks — Pages using bookmarks to show/hide visual groups may exceed the threshold in the raw layout even though users only see a subset at a time. The flag still applies because all visuals are loaded into memory and query simultaneously on page load.
- Drillthrough pages — These load on demand and may have a higher acceptable visual count.
Related Flags
- Non-Data Visuals — Decorative elements that contribute to visual count without displaying data.