Automatic query append

[huuhaa]

I get every month csv-file containing one month data. I like to have one table on Power BI containing all data from every month.

Currently i import new csv-file as new datasource, do some cleaning and append data into the "master" table with Append Queries -functionality.

Is there any way to make this full automatic? Like just add new file (with specific name) on folder and click refresh on Power BI?

Or is my only option to combine csv:s beforehand (in excel) and just refresh the master datasource to Power BI?

[SteveCampbell]

If you put all the csvs in a folder, you use Get Data > Folder. 
If you click edit, you can filter the Extension columnto make sure it is only csv, then click this button to comine all your files: 

You can then edit the data as usual, and any new files added to the folder will be combined in.

Note, all the data must be in the same format (Same Column names, datatypes) to combine. If they are not, you will need to use a function to prep them first.

[bazwen]

hi @SteveCampbell ,

I'm quite new to PBI. and also have the same objective as @huuhaa . However, what if the existing data already has some set of Applied Steps in the query editor. Would the same set of "applied steps" will be applied as well to the new data?

perhaps if you have link of video that contain this particular topic. Really appreciate it if you can share it