One to one the cardinality you selected isn't valid for this relationship

[syncwithconnex]

Hi,

I have a one to one relationship between two tables. One is called DesktopLicenseKey and the other is called QBPOSUsersWithSKU. Here are the fields:

LicenseKey

ID

UserName

UsersWithSKU

UserName

The UsersWithSKU table user name field is unique. The LicenseKey field user mail ID is unique. There are rows in UsersWithSKU that are missing from LicenseKey. How do I handle these errors?

[v-yingjl · Accepted solution]

Hi @syncwithconnex ,

If the [UserName] really has duplicate values, we can't set the relationship as 1-1, this could be the reason why the error throws out.

You can create measures like this to check whether the values are the same in the card visual for each table:

Countrows= COUNTROWS('LicenseKey')
Distinctcount = DISTINCTCOUNT('LicenseKey'[UserName])

You can also refer these simliar issues:

1. The cardinality you selected isn't valid for this relationship 
2. Can't Select 1:1 Relationship - No Duplicates in Data 
3. Cardinality you selected isn't valid 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[syncwithconnex]

If the tables should have a one to one relationship, then why does Power BI fail to allow me to choose one to one? The error is the cardinality you selected isn't valid for this relationship.

[Syndicate_Admin]

I had the same problem and the error was due because one of the columns was set as text while the other was as integer.

[themistoklis]

@syncwithconnex 

Have you checked that there are no duplicate values or the are no multiple cells with NULL or they are empty??