Forum Discussion
connecting to sharepoint sub folder
Hello,
I may have the problem solved by filters on the path of the files, for your reference if that would help:
I also have the problem that I want to query a sub folder under a Teams sharepoint which contains not only the to be queried files but also a lot of others, check the steps:
1. Still follow the steps to build a query to a sharepoint by Get data -> SharePoint folder, fill up the root path to the sharepoint, then the file list of all the files in the sharepoint is presented, with a column named as "Folder Path", in that column, each of the files' path are listed.
2. Quite simple now, filter this column by the sub-folder name that you are going to query, for me, I have to query into a subfolder under this sharepoint called "B1_Planning":
3. Then the follow ups will be quite normal operations in Power query. You will be finally get the query to the subfolder you filtered.
Thanks.
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.
