Forum Discussion
connecting to sharepoint sub folder
Helper Ihi jer91899,
Correct, these are the current way to get data, problem is lets say: https://sharepoint.com/sites/site belongs to a department, the department has a lot of folders and files.
Power BI has to go to the site, and read every single item within that site directory, before continuing step 4 which is to filter down to the folder you want
Common sense would say you can go to the sub-folder of that site directly, but that is not possible right now.
Combine with the fact that load anything from sharepoint takes way longer than other means. It is literally refresh and forget. Refresh, and forget you are working on it.
Ran into a similar issue where the solution I posted above wasn't working due to the load query failing.
The step-by-step approach to do this manually is outlined here https://learn.microsoft.com/en-us/power-query/custom-function, but in my case it was easier to create a temporary SharePoint site with a small number of files to build the query, and then go back and update the URL (set as a parameter) to point to the live site.