cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jseek Regular Visitor
Regular Visitor

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
jseek Regular Visitor
Regular Visitor

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

1 REPLY 1
Highlighted
jseek Regular Visitor
Regular Visitor

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

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 142 members 1,553 guests
Please welcome our newest community members: