How to Connect OneDrive Personal Files to Excel Power Query After Path Change
Question details
The user needs to reconnect Excel Power Query to a OneDrive Personal file after a recent update broke the previous file path format.
- Product
- Microsoft Excel / OneDrive
- Device & OS
- not provided
- Scenario
- Re-establishing a reliable data connection in Excel Power Query using a source file hosted on OneDrive Personal.
- Observed behavior
- Previous generated OneDrive file paths and older connection methods no longer work in Power Query due to a OneDrive ecosystem update.
Ensure you have an active internet connection and that the target source file is fully synced and accessible in your OneDrive Personal account.
Modify an Embed Link from OneDrive Web
Use OneDrive's embed feature to generate a stable, direct download link that Power Query can reliably access.
Because standard sharing links redirect to a web viewer, Power Query cannot extract raw data from them. Generating an embed link and changing its parameter forces a direct file download, bypassing the recent path generation changes in OneDrive.
Log into OneDrive on your web browser, right-click the target Excel file, and select 'Embed' to generate an HTML snippet.
Copy only the URL portion located inside the quotation marks (src="...") from the generated embed code.
Paste the copied URL into a text editor like Notepad. Locate the word 'embed' within the link and replace it with 'download'.
Open your destination Excel workbook, navigate to Data > Get Data > From Web, paste the modified download URL, and click OK to establish the connection.
Use the Copy Path Feature in Excel Desktop
Extract the file path directly from the open Excel file and format it for the Power Query web connector.
Experience Stable Data Management with WPS Office
If frequent ecosystem updates and broken file paths in Microsoft Excel are causing frustration, consider switching to WPS Office. It's a free, lightweight alternative offering robust spreadsheet tools, high compatibility with Excel formats, and stable built-in cloud syncing—saving you from constantly troubleshooting broken data connections.
- 1. Download WPS Office: Visit the official WPS website to download the free Office suite for your operating system.
- 2. Install and Launch: Run the lightweight installer and open WPS Spreadsheet in seconds.
- 3. Import Your Data: Open your existing Excel workbooks and continue analyzing your data without format compatibility issues.
Frequently Asked Questions
Why did my Power Query connection to OneDrive break unexpectedly?
Recent system updates to Microsoft OneDrive modified how file paths and sharing links are generated. Older direct URL structures are no longer supported, which disrupts established Power Query data connections looking for those specific paths.
Can I use the standard "Share" link from OneDrive in Power Query?
No. Standard sharing links are designed to open files within the OneDrive web browser interface. Power Query requires a direct download link (achieved by modifying the embed code or removing the ?web=1 parameter) to process the raw file data correctly.
Do I need to update my existing broken queries manually?
Yes. If your previous queries are failing to refresh, you must open the Advanced Editor or Data Source Settings in Excel, locate the old OneDrive file path, and replace it with the newly generated download link.
