Forum Discussion
Connecting OneDrive Excel file to PowerBI error message
I've followed the numerous videos and instructions out there but it seems Excel generates a link that is different from what everyone else gets. They get a "?web=1" at the end (which they instruct to remove anyways), but mine simply comes out as ".xlxs"
In OneDrive: "Open in Excel"
In Excel file: File > Info > "Copy Path"
In PowerBI: Get Data > Web > Paste link
Then I get the following error message:
Details: "The downloaded data is HTML, which isn't the expected type. The URL may be wrong or you might not have provided the right credentials to the server."
Any ideas? Thanks.
4 Replies
Anonymous
Refer to these articles: https://radacad.com/change-excel-source-in-power-bi-to-onedrive-for-business-no-gateway-neededhttps://www.youtube.com/watch?v=t4TzHu8THoA
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
Fowmy I have followed the video you shared. However, it seems the link he generated when he copies the Excel link includes ".sharepoint.com" whereas mine does not. This is the same for other articles, including the one above. Here is the link Excel generates for me: https://d.docs.live.net/11c062641d0b1dee/Consulting/City-Wide%20Count/Lot%20Count%20Database/Lot%20Count%20Database.xlsx
I have OneDrive Personal, if that makes any difference.
