Forum Discussion
Query Performance Slow 2,500 KB File Reading as 6GB
Hello, I need help figuring out why a small .csv file is coming into Power Query and reading as 6GB. I have a few merged queries in my workbook so I am wondering if that is whats causuing the slo...
HI Anonymous
It looks like when I merge and aggregate data from another table it increases the size significantly. In one case I merged a query and aggregated a sum of a column and the file read as 10GB. Does anyone know a way to not have this happen?
Thank you!
Eddy
Hi newtoPowerBI,
Have you try to expand summary columns in your merge table?(column which stored list, records, tables )
When you expand merge table, it will generate lots duplicate rows.
Regards,
Xiaoxin Sheng