Forum Discussion
Law Chong Seng
Nov 20, 2016Iron Contributor
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
SergeiBaklan
Nov 21, 2016Diamond Contributor
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
Feb 24, 2018Copper Contributor
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