Forum Discussion
Load error - relationships
You need to use the appropriate relationship for your data. If there are multiple session types for a single booking, then you cannot have a 1-to-1 relationship between tables. You'd need a many-to-one or a many-to-many relationship. Any time a relationship has a 1 side, the values on that side must be unique.
I will have a go at these things but that data logic doesn't make much sense to me. Surely I would only use a many to many relationship if I needed to relate multiple session types to multiple session bookings? I just want to relate a single session type to multiple session bookings. This works well in my dataverse model-driven power app, so is it just Power Bi that works like this and requires the different relationship. I want to be able to keep my single form column lookup on my session bookings form in my app, so can I just create the many to many relationship in Power Bi and then will it work?
Thanks in advance
If it's one-to-many, then use a one-to-many relationship, not a one-to-one. A one-to-one relationship requires unique values on both sides.