Folding-breaking step before a row filter
"Folding-breaking step before a row filter" is one of the performance checks Auditabi runs on a Power BI semantic model. n query(ies) apply a step that breaks query folding (index column, buffer, text function, unpivot…) and only filter rows afterwards. It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Move Table.SelectRows and column removals before the folding-breaking steps so the source does the heavy lifting.
What is detected
n query(ies) apply a step that breaks query folding (index column, buffer, text function, unpivot…) and only filter rows afterwards. The full table is pulled from the source before the filter runs.
Why it matters
Wrong in some filter contexts, slow, or fragile under change. Fix in the next iteration.
How to fix it
Move Table.SelectRows and column removals before the folding-breaking steps so the source does the heavy lifting.
Reference
Microsoft: Best practices — filter early
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.