combine_folder_files
Combine CSV or Excel files from a folder into a single Power Query table, with schema-drift safety and per-file error handling.
Instructions
Generate a robust combine-files-from-folder query as a new query: Folder.Files -> filter by extension -> per-file parse -> Table.Combine. Schema-drift safe: it does NOT use Power Query's default 'expand with a sample file' (which silently drops columns only present in later files). fileType = csv | excel. keepFilename adds Source.Name and Source.Folder Path columns; skipErrors wraps each file in try..otherwise so one bad file does not break the refresh. Refresh afterwards.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes | ||
| fileType | No | csv | excel | csv |
| skipRows | No | rows to skip before headers (default 0) | |
| delimiter | No | CSV delimiter (default ,) | |
| sessionId | Yes | ||
| folderPath | Yes | the folder path | |
| skipErrors | No | wrap each file in try..otherwise to skip parse errors (default false) | |
| keepFilename | No | add Source.Name and Source.Folder Path columns (default false) | |
| promoteHeaders | No | promote the first row to headers (default true) |