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.
Thanks, Greg_Deckler ..... I understand that.. Let me try to clarify my problem better with an example..
I have three distinct email names with 3 distinct ids, and after grouping only one of those emails appears in the preview. The other two emails can't be found. I have tried grouping by the ids, the email names, but am still only ending up with one of the three email names after grouping.
Winter_king94 I would try loading the query and then make a determination about whether all of the IDs are there or not. I would not trust the Preview pane for that as doing the grouping could switch which of the 1000 rows it grabs from the source system.