Business rule written inside a native SQL query
"Business rule written inside a native SQL query" is one of the maintainability checks Auditabi runs on a Power BI semantic model. n query(ies) embed a WHERE clause in a native SQL string. It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Expose a view in the warehouse, or apply the filter in Power Query where it is visible and foldable.
What is detected
n query(ies) embed a WHERE clause in a native SQL string. The rule is invisible from Power Query, cannot be traced by the audit, and drifts from the rules expressed in the model.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Expose a view in the warehouse, or apply the filter in Power Query where it is visible and foldable.
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.