Removing Duplicates

[EktaMaurya17]

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

[mussaenda · Accepted solution]

Hi @EktaMaurya17 ,

@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

[HotChilli]

Preview shows 1000 rows so it looks like everything's working fine.