Forum Discussion
Automate newly generated files in Power Query
I have a folder which generates each day new files. There are multiple files being generated with different names. In the names is also the day included when it is being generated. I need to imp...
So far I get the table form a M365 Sharepoint. But it could be that in the future it will be over a Delta Lake.
The table looks something like this:
| ID | Adress | Value |
| 123 | Street 1 | 50 |
| 789 | Street 2 | 60 |
And for each day I receive a new table in this form. The name is 2023-10-18_Data, 2023-10-19_Data, etc.
How can I tell Power Query that it needs to combine each new table into a new one? As far as I know I need to actively select table to be appended. But I need it to be automated for every table in a folder...