So I set up a group and it allocated a OneDreive for Business for the Group. I can connect to it from teh website but I dont see how to do it from the Desktop tool. I can sync the files locally but the whole point is I dont want to have set up a personal gateway - I want to use the shared onedrive for storing and syncing data and I want to create my reports in Desktop. Is this possible?
Similarly I dont see anyway to publish the reports in the group from Desktop?
Is this me not understanding something or a missing feature?
Edit:
Playing around in Excel and using it's File chooser to navigate around my Sharepoint site I believe I answered the first part of the question:
Source = Excel.Workbook(Web.Contents("https://mysite.sharepoint.com/sites/mv104/Shared%20Documents/Definitions/MV104%20Field%20Definitions..."), null, true),
I'm pretty sure that will work but would be happy to hear any feedback.
As for the sharing, Is the way to do that package it up in my workspace as a Content Pack and share with the group?
