All checks
Power QueryMaintainabilityMedium

Same server and database repeated across queries

"Same server and database repeated across queries" is one of the maintainability checks Auditabi runs on a Power BI semantic model. n queries repeat the same literal connection. It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Declare the server and database as parameters and reference them everywhere.

What is detected

n queries repeat the same literal connection. Moving from development to production means editing every one of them, and one forgotten query points at the wrong environment.

Why it matters

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

How to fix it

Declare the server and database as parameters and reference them everywhere.

Does your model fail this check?

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

Audit a model

More Power Query checks