Forum Discussion
Onedrive Connection to Power BI error: The downloaded data is HTML, which isn't the expected
This is not helpful - but I've found the solution. Use Google sheets instead which has a built in connector. Just unfortunate. The other posts on this topic are not helpful either
Super UserHi PowerBICouple - Go to the OneDrive web interface.
Right-click the file → Select Embed or Copy Link.
Modify the link to include /download if not already present.
Eg: https://onedrive.live.com/download?resid=<fileID>
Try accessing the direct download link in a browser. If successful, replace the Web.Contents link in Power BI.
For more details attached the solved threads:
Solved: Re: DataSource.Error: The downloaded data is HTML,... - Microsoft Fabric Community
Solved: DataSource.Error: The Downloaded data is HTML, whi... - Microsoft Fabric Community
I go to "Copy Link" i get the 1drv.ms link without any resid. The initial 1drv.ms link is set to "Anyone can edit"
I type it into browser and let it load I get a resid in the address bar. I then do
https://onedrive.live.com/download?resid=<resid>
Type that into the browser and I get:
This item might not exist or is no longer available
Hi PowerBICouple ,
Base on the error message, it seems that the OneDrive file may change the store location or be removed in the original location. Could you please check and try the following things?
1. Ensure that the OneDrive still exist there
2. Make sure it is still shared correctly with the necessary access rights
3. If the above ones are OK, please try to re-generate the link
4. Clear the permission of data source and re-connect it with the correct authentication.
Edit Or Remove Permission From Existing Data Source Connection From Power BI
5. Refer the following links to connect to OneDrive file
Use OneDrive for work or school links in Power BI Desktop - Power BI | Microsoft Learn
Connect To OneDrive Excel File From Power BI Desktop
Best Regards
This is not helpful - but I've found the solution. Use Google sheets instead which has a built in connector. Just unfortunate. The other posts on this topic are not helpful either
Hi PowerBICouple ,
It's glad to hear that you have gotten the solution. And thanks for sharing the solution here. It would be helpful to help others in the community find the solution easily if they face the similar problem as yours. Thank you.
Best Regards