Soterre PBI Analyzer scans your Power BI semantic models and reports and surfaces flags for conditions that may hurt performance, waste resources, or make models harder to maintain.
Each flag page documents what the flag detects, why it matters, exact trigger conditions, and what output you can expect.
| Flag | What It Detects |
|---|
| Unused Tables | Tables not referenced by any measure, relationship, or report visual |
| Unused Columns | Columns not used in measures, relationships, sort-by, or report visuals |
| Unused Measures | Measures not referenced by any other measure or report visual |
| Flag | What It Detects |
|---|
| Duplicate Tables | Tables with identical or near-identical schemas and row counts across datasets |
| Duplicate Columns | Columns that appear to be copies of each other within the same model |
| Duplicate Measures | Measures with identical DAX expressions across the same or different models |
| Flag | What It Detects |
|---|
| Calculated Columns | Calculated columns that could be replaced with measures or pushed to the source |
| Complex DAX Measures | Measures with deeply nested or excessively long DAX expressions |
| Complex DAX Columns | Calculated columns with complex DAX that increase model size and refresh time |
| Flag | What It Detects |
|---|
| Excessive Visuals | Report pages with too many visuals, causing slow rendering and high query volume |
| Non-Data Visuals | Decorative elements (images, shapes, text boxes) that do not display data |
| Flag | What It Detects |
|---|
| Automatic Hidden Tables | System-generated hidden tables created by Power BI auto date/time or other automatic features |