Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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/
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/