Remove Duplicate data

[blm001]

Hello,

I have an issue where I query a SQL DB and get back about 87k supposedly unique names.  When I was trying to create a relationship I was notified that I cold not make a 1 to 1 relationship. 

Long story short.  I have about 6 names that are in both upper and lower case. Even if in query editor I set it to remove duplicates, they still show up in Power BI.

So Query editor does see them as dups, but Power BI does.

Any ideas?

[12scml · Accepted solution]

Hi! I had this same issue with emails! I managed to fix it by selecting the column in the Query Editor, right-clicking, and selecting transform->lowercase and then selecting Remove Duplicates. There's also an UPPERCASE option and a Capitalize Each Word option that might help!

[blm001]

That did it!

So easy. Thanks!