Forum Discussion
newtoPowerBI
8 years agoNew Member
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...
Anonymous
8 years agoNot applicable
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
newtoPowerBI
8 years agoNew Member
HI Anonymous,
Here is a link to the data where most of the query is derived from.
https://www.dropbox.com/sh/5kzn1vm38mkis87/AABSRMdhGpGDi6TsOSkpZ5u5a?dl=0
Thank you!