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.