Appending Files, but not a set # of files...

[Michael_Hammer]

Good Morning PBI Community,

So, an ERP system of ours spits out files of roughly 10K lines in length via CSV format.  However, the number of files varies with the number of orders.  Sometimes it's 20 files sometimes 52 sometimes 9.  How can I get PBI or Power Query to append all of these regardless of the size.  Is there some sort of variable I could use?

Thanks,

Michael

[markvsql · Accepted solution]

The From Folder option in Power Query/Power BI Desktop will stack all files in the folder you specificy (including any subfolders). If you put the files you want to import into that folder and use the From Folder option, you will get them all. Then you just need to "Combine" them via the button at the top of the column listing Binary values. Then you woudl just need to filter out the column headgins (if any) from the files after the first one since those will be listed as rows. You can find more details here: http://excelunplugged.com/2015/02/10/get-data-from-folder-in-power-query/