98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Power BI training and help » Relationship error cardinality
Relationship error cardinality
Resolved · Low Priority · Version 365
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.
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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Power BI tip:Page and Tab ShortcutsCtrl + Page Up/Page Down: Navigate between pages. |