Forum Discussion
Zinaida_299
Mar 17, 2025Copper Contributor
Error loading Excel files from OneDrive Personal into Power Query
Suddenly a few days ago I started getting an error when loading any Excel file from OneDrive Personal into Power Query. To download I use Excel.Workbook(Web.Contents("https://onedrive.live.com/dow...
Kidd_Ip
Mar 19, 2025MVP
Please consider this:
- Verify the URL Format:
- Ensure that the URL you are using is in the correct format for downloading files. The new URL structure with migratedtospo=true might indicate a backend change in OneDrive's file hosting.
- Try generating a new download link by sharing the file and selecting the "Anyone with the link can view" option. Replace view.aspx with download in the URL.
- Use the Correct Privacy Level:
- Double-check that the privacy level in Power Query is set to "Public" for the data source. Go to Data Source Settings in Power Query and confirm this.
- Test with a Different File:
- Upload a new test file to OneDrive Personal and generate a fresh link. This can help determine if the issue is specific to certain files.
- Alternative Method:
- If the above steps don't work, consider using the OneDrive API or a different method to access the file. For example, you can sync the OneDrive folder to your local machine and load the file directly from the synced folder.
EDMD
Apr 06, 2025Copper Contributor
Hey Kidd_lp
Have you tried this solution?
Does this work for you?