Currently we use Excel for our dashboards with power query and power pivot. The power query dataset is set to grab all csv files in a particular folder and append them together. (as we have a folder that automatically has a new sales file added to it each week from our Backoffice system i.e. (Week 10 Sales 2024.csv this week, next week Week 11 Sales 2024.csv will be added to the folder etc...) This makes the job of having to add each weekly file to the table list redundant in excel, as I can just set the query pickup all the files in the folder add the data from any new file added to the sales folder to the end of the table. I can't seam to find a way using data bridge to do this? it appears you have to give it a set file name, so each time a new file is added to the folder, I would have to create a new table for it. This is going to be a deal breaker as power BI and excel can do this easily and so can Tableau with wildcard unions. Am I missing something?