Forum Discussion
Group By in power query taking too long time.
I have about 10 million rows and trying to groupby my data in Power BI by several columns. I've tried to do this with Power Query editor with "Group By" button but the performance is taking about 15-...
Thanks for your response Vijay_A_Verma v-jingzhang . I appreciate it. The source was from pc memory, csv.file. As you said i've tried to pre-summarize(Group.By) my data with Python script before loading it to Power BI. It is working fine and it reduced time from 25 minuts to 3-4.