relationship error cardinality

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Power BI training and help » Relationship error cardinality

Relationship error cardinality

resolvedResolved · Low Priority · Version 365

Relationship error cardinality

Dear Jens/Team,

Following the course I am trying to redesign my data models in a better way.

I have encountered an error when trying to set up a one to many relationship.

Currently, I use a calculated column formula to look up rates from a table of rates. I think I can replace this with a one to many relationship, as the rate key is unique in the rates table.

However, when I create the relationship I get the error "The cardinality you selected isn't valid for this relationship".

I think this should be one to many, but whatever combination a apply I get the same error message.

I have screenshots of the relationships, data model etc but don't know how to attach them here?

Thank you,


RE: Relationship error cardinality

Hi Martin,

Thankyou for your question on the forum.

Please can you send your screenshots via

Then we can look at the problem and hopefully arrive at a solution

Kind regards
Martin Sutherland
(Senior Applications Trainer)

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.


Training courses


Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


Power BI tip:

Page and Tab Shortcuts

Ctrl + Page Up/Page Down: Navigate between pages.
Ctrl + T: Create a new page.
Ctrl + Shift + F10: Toggle between fields pane and report canvas.

View all Power BI hints and tips

Server loaded in 0.06 secs.