Forum Discussion

newtoPowerBI's avatar
newtoPowerBI
New Member
8 years ago

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's avatar
Anonymous
Not applicable
8 years ago

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's avatar
    newtoPowerBI
    New Member
    8 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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