Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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.