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":
The result in Power query:
When I try to expand the "Children" column, it produces more Name-Children-Text columns.