Forum Discussion

KSveigaard's avatar
KSveigaard
Regular Visitor
10 years ago
Solved

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's avatar
    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. 

ankitpatira's avatar
ankitpatira
Icon for Community Champion rankCommunity Champion
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. 

KSveigaard's avatar
KSveigaard
Regular Visitor
10 years ago

Thanks. Got it now