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.
I had the same issue in the past. Turned out my issue wasn't with rows as Power BI is more than capable of handling 500k rows. My issue was appending the csv. The more csv files I threw it at, the slower it got regardless of how many rows it was in total. That's just one downside to using a sharepoint folder and appending several files with power query. POwer Query is not that good handling it in my personal experience.
I've since moved on and started using power automate to append new csv data onto a base csv file and using that csv as source.