Native SQL query in Power Query
"Native SQL query in Power Query" is one of the performance checks Auditabi runs on a Power BI semantic model. n query(ies) send hand-written SQL (Value.NativeQuery or Query=). It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Prefer navigation + native M transformations that fold; if SQL is required, put the logic in a view on the source and reference the view.
What is detected
n query(ies) send hand-written SQL (Value.NativeQuery or Query=). Every later step runs in the mashup engine instead of folding to the database, and incremental refresh cannot fold.
Why it matters
Wrong in some filter contexts, slow, or fragile under change. Fix in the next iteration.
How to fix it
Prefer navigation + native M transformations that fold; if SQL is required, put the logic in a view on the source and reference the view.
Reference
Microsoft: Query folding guidance
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.