Forum Discussion
Power BI Desktop Many to Many Relationships
Hi Xiaoxin, sorry for not getting back to you earlier.
Yes that is the case, the two outer tables have multiple records and not single entries so I agree Power BI won't support this.
I've remodelled the data tables to insteadof trying to have multiple records in a many-to-many relationship that all the columns from these tables are added to one table which is a work around.
Many Thanks Xiaoxin for all your help with this issue.
Regards
Bert.
Hi berta2b,
This is fine, but when I try and create a report using for example BookingsLink.BookingReference, BookingDate AND THEN BookingsEMails.EMailSent I get the 'Can't determine relationships between the fields' error although the many-to-many relationships exist.
As you mentioned, if you use the unique table key to link column which contains in multiple side, it will be works normal?
If this is a case, It seems like power bi not support direct mapping the multiple records to multiple records.
I'd like to suggest you use the unique key as the route to mapping those records.
Regards,
Xiaoxin Sheng
Hi Xiaoxin, sorry for not getting back to you earlier.
Yes that is the case, the two outer tables have multiple records and not single entries so I agree Power BI won't support this.
I've remodelled the data tables to insteadof trying to have multiple records in a many-to-many relationship that all the columns from these tables are added to one table which is a work around.
Many Thanks Xiaoxin for all your help with this issue.
Regards
Bert.