All checks
Structural and report checksData SourcesCritical

Local file paths in Power Query sources

"Local file paths in Power Query sources" is one of the data sources checks Auditabi runs on a Power BI semantic model. Power Query sources point at a local drive (C:\Users\…, Desktop, Downloads, a personal OneDrive folder). It is a critical finding: it breaks refresh, returns wrong numbers or exposes data, so it should be fixed before publishing. Move the file to a shared location (SharePoint, OneDrive for Business, a lakehouse) and expose the path as a Power Query parameter; configure a gateway for on-premises paths.

What is detected

Power Query sources point at a local drive (C:\Users\…, Desktop, Downloads, a personal OneDrive folder). The dataset refreshes on the author's machine and fails on the first scheduled refresh in the Service or on a colleague's laptop.

Why it matters

Breaks refresh, returns wrong numbers, or exposes data. Fix before publishing.

How to fix it

Move the file to a shared location (SharePoint, OneDrive for Business, a lakehouse) and expose the path as a Power Query parameter; configure a gateway for on-premises paths.

Does your model fail this check?

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

Audit a model

More Structural and report checks checks