Forum Discussion

Iron Contributor

Nov 20, 2016

Connect Onedrive Excel files to Power Query 2016

I have problem to connect Excel files in One drive to Power Query. I have doubt is the Onedrive allow this type of connection? Please share. Thanks

BI & Data Analytics

Need Help

SergeiBaklan

Diamond Contributor

Nov 21, 2016

Yes, it allows. Could be like Source = Excel.Workbook(Web.Contents("https://contoso-my.sharepoint.com/personal/contoso/Documents/UpFolder/myFile.xlsx"), null, true)

David Pearce

Copper Contributor

Feb 24, 2018

I think this answers the question for OneDrive for Business, but what about personal OneDrive folders? The similar URL from the browser looks like (in my case):
https://onedrive.live.com/?WT.mc_id=A77%5FBingHP&id=root&cid=777AA7AAAA7AAA77

I guess the real question is does OneDrive (for Personal) keep some attributes for both tenant/subscription/individual statically or dynamically.

Thanks in advance,

David