All checks
Power QueryPerformanceLow

Rows sorted in Power Query

"Rows sorted in Power Query" is one of the performance checks Auditabi runs on a Power BI semantic model. n query(ies) sort rows with Table.Sort. It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Remove the sort; order visuals with a sort-by column instead.

What is detected

n query(ies) sort rows with Table.Sort. The engine stores rows in its own order, so the sort costs refresh time and changes nothing in the model.

Why it matters

Hygiene and maintainability. Fix when touching the object.

How to fix it

Remove the sort; order visuals with a sort-by column instead.

Does your model fail this check?

Free static audit with the exact objects, no account, nothing stored.

Audit a model

More Power Query checks