Power Query Problems

Fix Excel Power Query Cannot Find Part of the Path Error

Nimra MalikNimra Malik Nov 18, 2026 869 views

Question details

Resolve a Power Query path error when users load a source workbook from a shared Google Drive folder.

Fix Excel Power Query Cannot Find Part of the Path Error
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.
Before you start

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.

Solution 1Recommended

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.

1
Test the source path

On an affected computer, paste the folder path from the error into the file manager. Check whether the folder and source workbook open.

2
Check Google Drive availability

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.

3
Compare drive letters

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.

4
Verify permissions

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.

5
Refresh the query

In Excel, select Data > Refresh All after confirming that the source file opens from the path used by the query.

Check the Google Drive Path and File Access
Check the path before regional settings: A missing drive or lack of file access is a more likely cause of this error than users being in different countries or using slightly different Excel versions.
Free Microsoft Office alternative

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.

Open and edit Excel-compatible XLSX and XLS filesUse a familiar spreadsheet interface for everyday workbook tasksWork with shared spreadsheet files without relying on Excel for basic editingGet a free, lightweight office suite
microsoft office alternative - wps office

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.