group by function in power query

[bercier]

hello,

I have loaded and converted over 300 text files in power query Excel 2016. Now I have about 1M lines that I am trying to do an aggregation on sum and count based on 2 criterias. I am running into some performance issues, it shows that my file is loading data for the last half hour but no rows are loading. Is there a way to help performance for the computer to complete this task?

thank you
sylvain

 

[sandy666]

try to use Table.Buffer() but without M-code I can't say more
Buffers a table in memory, isolating it from external changes during evaluation.