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
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
Hi, I'm having a similar problem...can you share the steps to solve this issue? Thanks
