Courses / Power Query (Get & Transform)
24. Connecting to Folder (combine files)
Using the Folder connector to load and combine multiple files with identical structure into one query.
Power Query M
Connecting to Folder (combine files)
Automatically load and merge many files with the same structure into one table using the Folder connector.
"I have 50 monthly CSV exports — I want one consolidated table without copying and pasting."
The Folder connector reads every file in a directory and you can use Power Query M steps to transform each file (parse, promote headers) and then combine them into a single table so you can refresh one query when new files arrive.
"I have 50 monthly CSV exports — I want one consolidated table without copying and pasting."
The Folder connector reads every file in a directory and you can use Power Query M steps to transform each file (parse, promote headers) and then combine them into a single table so you can refresh one query when new files arrive.