Data from multiple sharepoint sites

Hi  Tjordaske85 ,

Since you've mentioned that folder structures are the same for each sharepoint site, you can use custom functions in power query to get the data you need.

You will need to create a query and perform all the steps you need, from connecting to sharepoint to getting the final dataset. Then you will need to create a new custom function, and add the above steps to it. You will need to replace the file path with a variable so that you can re-use the same function for all sharepoint sites.

You can then create a table with only the name of the fully qualified sharepoint path as a column. Then add a column by invoking custom function and choosing the file path column as the parameter. The function will run through all steps for each path specified, and give you either a table, list or record as per your code in the output.

You can then append all of this data together and use it to filter out whatever data you need.

Kind regards,

Rohit

Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos!:)