Forum Discussion
How to make Power Query faster?
Does anyone know of a way to work with Power Query in a much faster way? I am merging 3 different tables, which have infinite rows, because they are tables that come from combinations of several oth...
Imrans123 Raw text files like CSV just aren't a very efficient source to load data from but it's definitely faster to load from one big one than from lots of smaller ones. Appending incrementally with Power Automate is a nice way to do the appending once rather than every time you refresh the query. You could get even better query performance if you used Power Automate to load the data to something more like a database with a query engine rather than a text file.
So, but on that particular report you will have no updates.