Forum Discussion
Anonymous
2 years agoNot applicable
Removing Duplicates
Hello all,
I am having a small issue in power query. I am applying all these steps to a data source:
After the second last step, I have 615 distincts values, the next step removes the values in duplicate. When I apply the step, my distinct values go up which shouldn't happen.. any solutions to this? I am attaching the recap of each step in order:
Any help would be appreciated!
Thanks,
Ekta
Hi Anonymous ,
HotChilli is right. it is because of the preview.
You can find it on the lower left
Now if you will click that one and select entire dataset, then it will give a preview without limit
2 Replies
- HotChilliCommunity Champion
Preview shows 1000 rows so it looks like everything's working fine.