Fix Excel Power Query Cannot Find Part of the Path Error
Question details
Resolve a Power Query path error when users load a source workbook from a shared Google Drive folder.

- Product
- Microsoft Excel Power Query and Google Drive for desktop
- Device & OS
- not provided
- Scenario
- Several users refresh an Excel workbook that references a source file in a shared Google Drive folder.
- Observed behavior
- Some users receive a DataSource.Error stating that part of the path cannot be found, while others can access the source.
Identify the full source path shown in the error and confirm which source workbook the query needs. Compare that path with the location accessible on a computer where refresh succeeds.
Check the Google Drive Path and File Access
Use this solution when the query refers to a drive letter or folder that is unavailable on an affected computer.
On an affected computer, paste the folder path from the error into the file manager. Check whether the folder and source workbook open.
Open Google Drive for desktop and confirm that the affected user is signed in and can access the shared folder. Check that streaming or offline availability is working as needed.
Compare the source location on working and affected computers. If the query uses G:, configure the Google Drive mount or drive mapping consistently, or update the query to use the accessible path.
Open the shared folder in Google Drive and confirm that the affected user has permission to access both the folder and source workbook. Ask the owner to grant access if needed.
In Excel, select Data > Refresh All after confirming that the source file opens from the path used by the query.

Update the Power Query Source Path
Use this solution when the source file is accessible but the query points to an outdated or user-specific location.
Use a Shared Source Location and Connector
Use this approach to avoid relying on different local drive letters across users.
Work With Excel Files in WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Excel file formats, making it easy to migrate everyday workbook work. It does not fix Microsoft Excel Power Query connection errors.

Frequently Asked Questions
Why does the same Power Query path work for one user but not another?
The drive letter, Google Drive mount, file availability, or permissions may differ between computers. Paste the exact source path into each user's file manager to check whether it opens.
Where can I find the path used by a Power Query?
In Excel, select Data > Queries & Connections, right-click the query, and select Edit. Inspect the Source step under Applied Steps or open Home > Advanced Editor.
Does every user need the same drive letter?
If the query contains a fixed path such as G:\, every user refreshing that query must be able to access the source at that path. Alternatively, update the query to use a shared location accessible to everyone.
Will changing regional settings fix a missing path error?
Regional settings are less likely to cause a missing-path error. First check the exact source path, drive availability, and permissions; investigate regional settings if a later error involves dates or number formats.
Can WPS Office repair an Excel Power Query connection?
No. Check or change the connection in Excel's Power Query Editor. WPS Spreadsheet is an alternative for opening and editing compatible workbook files, not a repair tool for Excel Power Query.




