Forum Discussion

Ismail94's avatar
Ismail94
Frequent Visitor
4 years ago

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-...
Need Help
Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

Best best would be load the data in SQL Server (if you don't have access to SQL Server instance - SQL Server Express is free and can be installed on Desktop). Then fetch the data from SQL Server into PQ and while fetching it from SQL Server, issue Group by SQL statement.

Group by in SQL Server is quite faster than native PQ group by.