Merging of data from all files in folder in Power BI
This article describes how to merge rows from all files in some folder – without working with them separately. Its my favorite feature in Power BI (Power Query) 🙂
We will use this folder that contains timesheets of employees.
In Power BI Desktop go to Get Data, select folder and find the folder with files.
Confirm and new query is created. But this query only makes the list of files, which isn´t what we need – since we need the data. Click on Combine / Combine & Edit.
Select, which content from all files should be loaded (it must be the same table or same sheet in all of files).
Then the final query, containing data from all files, is created. Off course, the connection is live and any changes in original folder (including adding of files or removing of them)