Reply
Regular Visitor
Posts: 25
Registered: ‎07-28-2015
Accepted Solution

Pulling data into PowerQuery from an Excel file on OneDrive

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.


Accepted Solutions
Highlighted
Regular Visitor
Posts: 25
Registered: ‎07-28-2015

Re: Pulling data into PowerQuery from an Excel file on OneDrive

This was due to an out of date version of PowerQuery.  A more recent update has made pulling from data on Onedrive easier.

View solution in original post


All Replies
Highlighted
Regular Visitor
Posts: 25
Registered: ‎07-28-2015

Re: Pulling data into PowerQuery from an Excel file on OneDrive

This was due to an out of date version of PowerQuery.  A more recent update has made pulling from data on Onedrive easier.