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.
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