Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have mostly figured out how to connect files and models in PowerBI, but I have an issue with files on OneDrive. I can't figure out how to bring in data from an excel file on onedrive into my data model using PowerQuery. If I put in the address of the file, it states the following error:
"DataSource.Error: The downloaded data is HTML, which is not the expected type. The URL may be wrong, or you may not have provided the right credentials to the server."
I have to be able to source this data entirely from the cloud.
Solved! Go to Solution.
This was due to an out of date version of PowerQuery. A more recent update has made pulling from data on Onedrive easier.
This was due to an out of date version of PowerQuery. A more recent update has made pulling from data on Onedrive easier.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
41 | |
30 | |
26 | |
21 | |
17 |