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

Hi Xiaoxin, thanks so much for your reply.

 

I have created this unique table, BookingsLink which has unique keys allowing the Many to one, One to Many between the two other tables.

 

My problem is although this relationship has been setup within Power BI Desktop 'Relationships' where I would think would resolve this, I can't access columns from the Table(Many) tables in one tabular visualisation report.

 

There are no blank keys, the Link table contains just the unique keys and no blanks.

 

Thanks again.

 

Bert

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi berta2b,

 

Did you check the 'cross filter direction' option at relationship setting? If it has setting to 'single', the relationship only works on one side, you can modify it to 'both' to work through it.

 

Regards,

Xiaoxin Sheng