Forum Discussion
Append data
I would think that you could use a Folder query (Combine Binaries) for this. You would place all of the Excel files in a single folder. Then you create a Folder query and select one file as your sample file. You do your required transformations and save the query. A Folder query will apply the transformations to every file in the folder and append all of them together at the end. So, when next month comes around, you just refresh and all of your data is there.
You cannot do that with PowerBI. You will need to prep this data somewhere else. I posted a solution to a similar question today that uses Excel. This has the advantage that Power Query in Excel is the same as the Query Editor in PowerBI so you can do your the same data transformation by just copyign and pasting the query from PowerBI to Exel.
See my reply here I include a sample excel workbook.