Hardcoded servers / endpoints in Power Query
"Hardcoded servers / endpoints in Power Query" is one of the data sources checks Auditabi runs on a Power BI semantic model. Server names, database names, web endpoints or file shares are written as literals inside partition queries. It is a critical finding: it breaks refresh, returns wrong numbers or exposes data, so it should be fixed before publishing. Declare the endpoint once as a Power Query parameter (or use Fabric deployment-pipeline rules) and reference it from every query.
What is detected
Server names, database names, web endpoints or file shares are written as literals inside partition queries. Moving from dev to prod, a server migration or a credential change means editing every query by hand.
Why it matters
Breaks refresh, returns wrong numbers, or exposes data. Fix before publishing.
How to fix it
Declare the endpoint once as a Power Query parameter (or use Fabric deployment-pipeline rules) and reference it from every query.
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.