Automate newly generated files in Power Query

Hi Paritae ,

If your files are in a network folder, then you'll want to use the Folder Connector. You'll also need a gateway if you want to refresh in the Service:

https://learn.microsoft.com/en-us/power-query/connectors/folder 

If your files are in a SharePoint folder, you'll want the SharePoint Folder connector. No gateway required:

https://learn.microsoft.com/en-us/power-query/connectors/sharepoint-folder 

These connectors both work essentially the same way. The part you're looking for is where you get the option to "Combine & Transform" or something similar to that wording. This will allow you to filter to an entire folder, transform all the files in the same way based on a sample file, and append them all at the end.

Regarding your new date column, I'd need to see an example of one of your file names to be able to give you the right code, but it should be easy enough to implement with the above connectors by adding it, then slightly adjusting which columns get removed by the auto-generated code.

Pete