Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi there,
I working on table that more than 10M rows, I try to grouping and expand column in Power Query by test table (1M rows) by this:
= Table.Group(#"Added Combine Column", {"CombineXY"}, {{"Count", each Table.RowCount(_), Int64.Type}, {"Partition", each Table.AddIndexColumn(_, "MSindex",1,1) , type table [X_Col=nullable text, Y_Row=nullable text, TOTALVOLUME=nullable text, TRUEVERTTHK=nullable text, TRUETHK=nullable text, XXX=nullable text, CombineXY=text, MSindex=text]}})
= Table.ExpandTableColumn(#"Grouped Rows", "Partition", {"X_Col", "Y_Row", "TOTALVOLUME", "TRUEVERTTHK", "TRUETHK", "XXX", "MSindex"}, {"X_Col", "Y_Row", "TOTALVOLUME", "TRUEVERTTHK", "TRUETHK", "XXX", "MSindex"})
That good for test table but doesn't work when apply to working table, run very long time and show 'memory not enough'. May I grouping and expand column on the DAX Studio and how to use it.
Chris Webb has a couple of blog posts on that topic
But you also want to ask yourself - do you really have to merge, or can you just join the tables in the data model?
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!