Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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

  • mussaenda's avatar
    mussaenda
    Community Champion

    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

  • HotChilli's avatar
    HotChilli
    Community Champion

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