Regarding relation between 2 table , must have unique values

[JENS]

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 values

The left table  is where we have the absence on employees ( one person have 17 days, and the emplid is there 17 times)

The right table is where we have the employee stamdata (name, adress and so on) end the emplid is there only once.

In SQL server 2008 r2, there is no issue to relate these fields. what is the best way to set this up. 

[Anonymous · Accepted solution]

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.

[Anonymous · Accepted solution]

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]

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]

@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,

[ovetteabejuela · Accepted solution]

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

[JENS]

that might work, but im unsure how to make it.