All checks
Power QueryMaintainabilityMedium

Two queries with an identical body

"Two queries with an identical body" is one of the maintainability checks Auditabi runs on a Power BI semantic model. n query(ies) share the same M code. It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Keep one query and reference it, or turn the shared part into a function.

What is detected

n query(ies) share the same M code. A fix applied to one of them leaves the other behind, and the two tables drift apart without anyone noticing.

Why it matters

Wrong in some filter contexts, slow, or fragile under change. Fix in the next iteration.

How to fix it

Keep one query and reference it, or turn the shared part into a function.

Does your model fail this check?

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

Audit a model

More Power Query checks