Forum Discussion
Keep getting unique values error when making a relationship
Hi all, I've been trying to create a relationship between two tables and keep getting the "You can't create a relationship between these two columns because one of the columns must have unique va...
Hi,
I think there is another way to prove if the values are actually unique or the view in Power BI makes you believe: go to the "Data" view (where you can see the content of your tables) and "Copy Table" via right click on the table you want to prove. Then open an empty Excel file and paste what you have copied. In Excel you can check duplicates with a marking condition. Do this separately for both tables.
What you can also do is to create a table and create a relationship to both tables.
DISTINCT('YourTableName'[YourColumnName])
I hope this is a help for you.