Power QueryPerformanceLow
Duplicates removed in Power Query
"Duplicates removed in Power Query" is one of the performance checks Auditabi runs on a Power BI semantic model. n query(ies) call Table.Distinct. It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Deduplicate in the source with a view, or fix the grain upstream.
What is detected
n query(ies) call Table.Distinct. Deduplication is a buffering operation: it breaks folding and forces the whole table into memory during refresh.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Deduplicate in the source with a view, or fix the grain upstream.
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.