Forum Discussion
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
Yes, it allows. Could be like Source = Excel.Workbook(Web.Contents("https://contoso-my.sharepoint.com/personal/contoso/Documents/UpFolder/myFile.xlsx"), null, true)
Hi Sergei, is there a way to reference a shared folder on OneDrive for Business? The scenario is I have a report and a subfolder of workbooks saved in one of my ODB folders. The Query Connection was created in desktop Excel's Power Query using synced local files. Now I'd like to give a colleague access to the report and source data via ODB. Assuming I've given the colleague a link to the folder, can I modify the Query to point to the corresponding source on ODB? Or is there a better way to do this? Thanks!