Martin has attended:
Power BI Modelling, Visualisation and Publishing course
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,
Martin
RE: Relationship error cardinality
Hi Martin,
Thankyou for your question on the forum.
Please can you send your screenshots via info@stl-training.co.uk
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.