Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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!
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!
That did it!
So easy. Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |