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.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

HI berta2b,

 

Power bi not support many to many relationship, you need to use table which has the unique key to link to those tables.

 

For example:

 

Table(Many)    ——>     Table(one)     <——      Table(Many)

                   (Many to one)               (one to many)

 

BTW, multiple blank records also will identified as the duplicate records, if your unique table contains them, you should remove them before create relationship.

 

Regards,

Xiaoxin Sheng

KarenSofia62's avatar
KarenSofia62
Regular Visitor
8 years ago

How to put dynamic role level security on this case?