Query editor: Remove duplicates is removing non-duplicates

[GES_1609]

Hello

I am trying to remove duplicate rows based on one specific column and it's set of values. However, when i use the remove duplicates tool, it removes more rows than there are duplicates.

When i try the keep duplicates function, it only keeps those rows that are duplicated based on the specific column I have highlighted. However, when I try remove duplicates, it removes far more rows.

I have extracted to excel and excel correctly removes the duplicates, so I am not sure what the problem is?

[saud968]

If the column is in text format, I recommend choosing Add custom column using "Text. Proper" and then the column name. This should help fix the issue

Best Regards

Saud Ansari

If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!

[RadkaProefo]

Hello,

I have the same issue, did you fine some solution?

[amitchandak]

@GES_1609 , IF you want to remove duplicate rows .Then select all columns or do not select anything and then do it.

Or select a set of columns, based on which you want to delete duplicates

Power Query Table.Distinct (Remove Duplicates)- https://youtu.be/DlpWgJuytuM

[GES_1609]

I have selected a single column to base my duplicates. I have even tried including other columns to help but I am still having the above issue