Forum Discussion
You can't create a relationship between these two columns...
I need some help figuring out why I continue to recieve the "Create Relationship" error "You can't create a relationship between these two columns because one the columns must have unique values." ...
Anonymous
Check that both columns you are using as part of the relationship are of the same data type (Text, Whole Number, etc). Sometimes if one column is still labeled as 'any' it can cause issues. Also - you can try to trim/clean the columns prior to removing duplicates.
Hi Anonymous.
Perhaps you can try to extract two table serial number value and create a bridge table with unique value to link these two tables, it should prevent the relationship analysis issues.
Regards,
Xiaoxin Sheng
I have extracted the data, but no change. It's like Power BI has determined that there are too many values in the table for there to be unique values in it. The table has 173K items, all unique.