0

I first upload an Excel file to Onedrive, then go Onedrive and share the file, getting a link with editing rights.

I then go to Power query Data - New query - From other sources - From Web and paste the link there. But Power query seems to treat the data as a web page, not an Excel file.

I also tried everything suggested here: https://www.sqlchick.com/entries/2014/8/17/using-power-query-to-get-data-from-an-excel-file-in-onedrive-via-url

Still I seem to get an internet page, not an Excel file.

Note the word "Document" in the left part, instead of "Sheet1":

enter image description here

The result in Power query:

enter image description here

When I try to expand the "Children" column, it produces more Name-Children-Text columns.

1 Answer 1

0

The instructions in the SQL Chick blog still work OK for me, editing the Excel Online link for download. Here's the link I used, which should work for anyone using Anonymous credentials:

https://onedrive.live.com/download?&resid=4FA287BBC10EC562!467

The change since the blog was written in 2014 is in the other credential options for private files - none of them work any more AFAIK.

2

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .