Connect Power Query to a whole SharePoint folder
This tutorial describes, how to connect Power Query to a SharePoint folder. This can be quite useful - SharePoint is generally online and therefore it is a nice source for files.
Following tutorial makes sense for Power Query in Excel as well as for Power Query in Power BI.
Let´s start with selecting of SharePoint folder in sources:
Then write the SharePoint address:
New list of files appears, but we can´t combine them now - usually we have to start by folder selection. So let’s click on Transform data:
Use a filter to select the folder to be connected:
Then "unroll" the files and select the files or tables to be loaded:
And that’s all. Data from all files are merged in a single query: