Forum Discussion
Solved
Remove duplicates doesn't work
Hi all, I'm facing a very common problem regarding the remove duplicates function in power query. If I try to remove duplicates from the column "username", not all the duplicates are removed (Link f...
Looking at your data, these rows aren't duplicates since Power Query is case-sensitive.
If you want these to be considered the same, I'd recommend adding a step to transform to all lowercase before removing duplicates.
I just tried to hit Refresh Preview, but it doesn't work. That's really strange because it always worked in the past.
Here there is the csv file (Link for the csv file - open it with Firefox because the other browers can't open it)
Looking at your data, these rows aren't duplicates since Power Query is case-sensitive.
If you want these to be considered the same, I'd recommend adding a step to transform to all lowercase before removing duplicates.