Forum Discussion
Solved
Group By in Power Query
Hello, I am working a data set that is too large to load into Power BI. To limit the data I am trying to group by. My problem is that when I group by, not all the unique email names are being br...
- Thanks everyone for you help. I found the solution by reordering my steps and doing the group by earlier in my process rather than as the last step.
Seeing as your data set is so large, you just might not be getting all of the values in the preview, but if you load your data set, they will be there.
--Nate
Unfortunately, whatever I see in my preview is the only data that loads into desktop. Anything not in the group by preview doesn't flow through.
I would try grouping on the two columns, and use the "All Rows" aggregation. If that gives you all of your unique values, then use the expand columns aggregations.
--Nate