Forum Discussion

blm001's avatar
blm001
Advocate I
9 years ago
Solved

Remove Duplicate data

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?

Need Help
  • 12scml's avatar
    12scml
    9 years ago

    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!

2 Replies

  • 12scml's avatar
    12scml
    Resolver I
    9 years ago

    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!