Forum Discussion
Data Source Error when loading into Power Query
Hi Zinaida,
Thank you for reaching out to Microsoft Fabric Community Forum.
Microsoft has recently changed the URL structure for OneDrive Personal shareable links, which may be causing the issue.If possible, move the file to OneDrive for Business and use the SharePoint Folder connector in Power BI. Go to Get Data > SharePoint Folder, enter your SharePoint or OneDrive for Business site URL, locate your file, and load it into Power Query. When prompted, sign in with your Microsoft credentials. This ensures a stable connection without relying on changing OneDrive links.
If that’s not an option, you can manually download the file to a local folder and connect Power Query to it.
For reference: https://answers.microsoft.com/en-us/msoffice/forum/all/onedrive-embed-url-format-change-breaks-all/49430bbc-d99c-44b5-a881-55e35446a77c
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
Vinay Pabbu
Hi Zinaida Could you try these please
Generate a direct download link:
- Share the file in OneDrive and copy the link.
- Replace the older link in your query with the copied link.
Update Power Query:
Excel.Workbook(Web.Contents("copied-link-here"), null, true)
Set privacy level:
- In Power BI, go to Data Source Settings and set Privacy Level to Public.
Hi, I have already tried all these options. Nothing works.
