Forum Discussion
Can´t create a relationship between two columns because one of the columns must have unique value
KSveigaard basically what that error is complaining about is that relationship you're trying to create from column within 'FROM' table to your column in 'TO' table has issue. one of that column must have unique product numbers. you can't have Many to Many relation but only One to Many or Many to One relation. So ensure that one of the table has unique product numbers and then there won't be any issue.
I got my data from Excel. I'm sure that there is no blank and no duplicated row in this table, and order ascending the column and there are no nulls on TOP. Additionally, I used the option eliminate duplicates in Power BI and after that the option eliminates blanks. But I wasn’t able to make the data relationship.
I checked in PowerBI Data View the data table and I have this: “TABLE: table name (5.946 rows) COLUMN: column name (5.945 distinct values)”
I don’t understand why I can’t make the data relationship. Can anybody help me?
Helper II am having the same issue, I'm pull data from an R script where I state only to select unique non-null values and then have added a step in Power Query to replace nulls and blacks with "ISSUE ROW!" and then also remove duplicate rows - However I still cannot define the relationship