ReportPerformanceLow
Report filter applied to a fact-table column
"Report filter applied to a fact-table column" is one of the performance checks Auditabi runs on a Power BI semantic model. n report or page filter(s) target a column of a fact table. It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Filter on the dimension that carries the attribute.
What is detected
n report or page filter(s) target a column of a fact table. Filtering the fact instead of the dimension scans the largest table in the model on every interaction.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Filter on the dimension that carries the attribute.
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.