Forum Discussion
Data Grouping Breaks Query
Not sure if this is the correct place to ask - but I have a query set up to pull data from another workbook and when I try to refresh with grouped columns Excel completely freezes and I have to force...
Ask yourself this: WHY do I want to do a GROUPING of my data? Especially in light of the fact that Excel does a nice job with Pivot Tables that does the grouping for you, and gives you options not available in Power Query.
How many records are we talking about? I have sucessfully queried several million into an Excel PowerPivot model (NOT a sheet), then left it up to the users to do their own grouping in a Pivot Table.