Forum Discussion

JENS's avatar
JENS
Frequent Visitor
9 years ago
Solved

Regarding relation between 2 table , must have unique values

Im new at this, and have tryed to read the other solutions regarding the same queastion. error : You Can´t create a relationship between these two columns because one of the columns must have unique...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi JENS

     

    I assume you tried to establish a relationship between both emplid columns.

    If [EMPLID] in EMPLTABLE is unique & there are no nulls in EMPLTABLE[EMPLID], it should work.

     

     

     

  • ovetteabejuela's avatar
    ovetteabejuela
    9 years ago

    Why not make a unique employee table if none of the two are.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi JENS

 

I assume you tried to establish a relationship between both emplid columns.

If [EMPLID] in EMPLTABLE is unique & there are no nulls in EMPLTABLE[EMPLID], it should work.

 

 

 

JENS's avatar
JENS
Frequent Visitor
9 years ago

I have made sure that there isent any null, and empltable.emplid has 9307 pcs. of unique numbers 100001,100002 and so on.

it still dont work

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    9 years ago

    JENS

     

    As you said the right table is the dimension table which contains unique empid values. Please delete the data source and re-import the table into Power BI Desktop to see if it still works.

     

    If the issue still persists, please create a support ticket.

     

    Regards,