All checks
Power QueryReliabilityLow

Rows kept or removed by position

"Rows kept or removed by position" is one of the reliability checks Auditabi runs on a Power BI semantic model. n query(ies) keep or remove rows by position (Table.Skip, Table.FirstN, Table.Range). It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Filter on a value instead, or fix the export so the shape is stable.

What is detected

n query(ies) keep or remove rows by position (Table.Skip, Table.FirstN, Table.Range). Position is not a contract: one extra header line in the source shifts everything.

Why it matters

Hygiene and maintainability. Fix when touching the object.

How to fix it

Filter on a value instead, or fix the export so the shape is stable.

Does your model fail this check?

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

Audit a model

More Power Query checks