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. 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

I am having the same issue but the solutions offered on this page are not solving the problem. Any other suggestions?

 

In spreadsheet 1 my column is: Account Name

In spreadsheet 2 my column is: Account Name

 

There are not duplicates, nor are there any blanks.

JoaoMachado's avatar
JoaoMachado
Icon for Advocate I rankAdvocate I
9 years ago

I have the exact same issue. No redundant data, no null rows... Thanks in advance for whoever may help us!

  • MassimoSolcia's avatar
    MassimoSolcia
    Regular Visitor
    9 years ago

    Same here, but I got it: in the Excel the table has no NULL, but when loaded in PowerBI I found rows with NULL.

    Go to in the Data View and order ascending the column, nulls should appear on TOP.

     

    Cleared the NULLs, I'm able to create the relationship.

     

    Hope it helps,

    Massimo

     

    PowerBI Desktop Version 2.46.4732.721 32-bit (may 2017)