Forum Discussion
Apply Power Query to all files within folder then append together
Hi All, We had a Power BI report which read in a number of excel files and applied a variety of Power Query transformations to make the data legible for visualisations. This process made the repor...
You can refresh against the new file, but you'll need to refresh against all the files each time too.
Pat
Hi there,
Thanks for your reply (And sorry for the delay in getting back to you on this!!)
Would this also be the case if we were to use incremental refresh, we have premium capacity so can utilise that.
My only concern is that with potentially a new file each week, this refresh will become quite long and potentially unstable in the long term.