Forum Discussion
apply automatically query steps on new files
Are the files all in the same format, for example csv (comma separated values)?
Is it important that each file ends up in a separate table?
You can use Get Data - Other - Folder to ask Power Query to grab all files in a specified folder. On each refresh, all data in that folder will be read so when new files are added, they will be read into the model upon refresh. You can also use all methods available in Power Query to shape the data as you see fit. All input will however end up in one table, but with a column containing the file name so it should be a simple matter to extract the date from the file name in that column in order to allow processing of date separated data.
Hope this helps!
Are the files all in the same format, for example csv (comma separated values)?
Is it important that each file ends up in a separate table?
You can use Get Data - Other - Folder to ask Power Query to grab all files in a specified folder. On each refresh, all data in that folder will be read so when new files are added, they will be read into the model upon refresh. You can also use all methods available in Power Query to shape the data as you see fit. All input will however end up in one table, but with a column containing the file name so it should be a simple matter to extract the date from the file name in that column in order to allow processing of date separated data.
Hope this helps!
Hi, very useful. Supplementary question: does this work as an update to the main table or a refresh? i.e. if an old file is not deleted, is there a risk of duplication or is the table simply overwritten?
