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 newtoPowerBI,
Can you please share pbix file and the csv file for test ? It is hard to find out the issue from your query formula.
Notice: please do mask on sensitive data before sharing.
Regards,
Xiaoxin Sheng
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