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...
Dude, it has about 500,000 rows. I pulled the data through a folder, where there were several CSV files and merged them to have only one table. This final table has more or less 500,000 rows.
OK. Half a million rows is likely small enough to buffer the component tables so you can join them in memory. Loading CSVs from a folder will be slow no matter what but if you buffer them after loading, you should be able to do merges and transformations pretty quickly on tables that small.
I'd recommend checking out parry2k's post here for more detail on buffering: