Forum Discussion
Helper IIICan't Relate Two Tables
Hello!
I need to create a relationship between two tables and I keep getting errors; it tells me the values need to be unique. I think I figured out why it does not think the values are unique. My "unique" table has the following values: 0015.2, 0015.20, 0015.200, among other similar values (0015.3, 0015.30). They should be unique, according to business process, the numbers are different, but I think Power BI is treating them as numbers and therefore not unique.
How can I fix this so I can relate the tables?
No, one table with unique values is enough.
But the table that is supposed to have unique values needs to be cleaned and removed of dups afterwards. If you end up with less rows than before, you know that your unique values are actually not unique and can further investigate.
9 Replies
SeanCommunity Champion
Have you tried converting the Columns to Data Type: Text in the Query Editor?
New2PowerBIYes; the data type for both is text right now.
- Sean
Do you have blanks in those columns?