try … otherwise hiding a failure
"try … otherwise hiding a failure" is one of the reliability checks Auditabi runs on a Power BI semantic model. n query(ies) wrap a step in try … otherwise with a constant fallback. It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Let the refresh fail, or record the failure in a column you can monitor.
What is detected
n query(ies) wrap a step in try … otherwise with a constant fallback. Any failure becomes a default value, and the report shows a plausible number computed from nothing.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Let the refresh fail, or record the failure in a column you can monitor.
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.