Can´t create a relationship between two columns because one of the columns must have unique value

Hi In Desktop Power BI, I have made a report, with 3 excel files, and want to make a link between these excel files, In file A: I have the "poduct number", and lots of other product informat...

ankitpatira
10 years ago
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.

TristanKuesters

Resolver I

9 years ago

Unique means, that the sales person on one of the both tables should be not be double (or more) in several rows.
So check, if the sales person in the first table is only one in the table!