Error message on building a relationship

[Anonymous]

Please help me with the following error:

Error Message:
Failed to save modifications to the server. Error returned: 'Relationship '2ae3bfcd-91c0-4708-b898-46db48b8fad1' between columns 'Operational Daily Cube (2)[Customer.0 Customer]' and 'Sheet3 (3)[Description]' has the TO end cardinality set to Many. TO end cardinality must always be set to One.
'.

[v-piga-msft]

Hi @Anonymous，

The answer of @Phil_Seamark should be right, Power BI does not support Many to Many.

Have you solved your problem?

If you have solved, always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need additional help, please feel free to ask. If you could provide more details, that should be better.

Best Regards，

Cherry

[Phil_Seamark · Accepted solution]

HI @Anonymous

At least one side of a relationship needs to use a column that has unique values (including blanks)