"TO end cardinality" error

[RMDNA]

Hi all,

I'm getting an odd error when I try to create a relationship between two tables. Even when I've created invalid relationships in the past, it usually throws normal errors that I can deal with (circular dependency, etc.).

However, I'm trying to create a 1:1 relationship, and I'm getting this very confusing notice. Data is loaded from a .csv.

[v-yulgu-msft]

Hi @RMDNA,

If you want to establish a 1:1 relationship, please ensure that the values of [Customer Code] in both tables are unique (without duplicate). The above error occurs once you attempt to create a many to many relationship between two tables. In your scenario, you could "Remove Duplicate" in Query Editor for both tables, then, try to create the relationship again, the error might be resolved.

Regards,

Yuliana Gu