Forum Discussion

berta2b's avatar
berta2b
Icon for Helper I rankHelper I
9 years ago
Solved

Power BI Desktop Many to Many Relationships

Hi there guys, have an issue with typical many-to-many relationships in Power BI desktop. Here's my scenario: Bookings (30 columns)        BookingsLink                       BookingsEMails (20 ...
Need Help
  • berta2b's avatar
    berta2b
    9 years ago

    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.

berta2b's avatar
berta2b
Icon for Helper I rankHelper I
9 years ago

Hey Xiaoxin, I have the sample file prepared for you. How can I get this sent as I can't add attachments to this message?

 

Many Thanks.

Bert

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi berta2b,

 

You can upload it to onedrive and paste the link here.

 

Regards,

Xiaoxin Sheng