Forum Discussion
connecting to sharepoint sub folder
Your solution works for Power Query in desktop. I'm trying to port my desktop data sources to dataflows. I cannot browse the contents of the Sharepoint document library far enough to get to my data sources.
I suppose I could rename my folder to 00mydatafolder, but that would only crowd out the other folders and files used by other people in my department. It isn't really a feasible solution.
Connect to SharePoint as usual, then in the formula bar in the query editor change SharePoint.Files to SharePoint.Contents
This will change the pulled data view to a table allowing you to click into the word "table" on the left of the rows of data so you can navigate to the relevant directory then draw down on the data.
You can also do this for parent folders with subdirectories.