Forum Discussion
manytomany
i was going through many to many relationship and came across below article , how to create accountcustomer bridge table as highlighted below
https://learn.microsoft.com/en-us/power-bi/guidance/relationships-many-to-many
Hi powerbiexpert22 ,
please refer below video to create the bridge table :
https://www.youtube.com/watch?v=urTwxelK-Xc
Thanks,
Ankita
7 Replies
Hi powerbiexpert22 ,
In the recent version of Power BI Desktop, we have the ability to create many to many relationship, please update your Power BI desktop using below link :
https://www.microsoft.com/en-us/download/details.aspx?id=58494
If you still want to go with previous method mentioned in your message using bridge table, please refer below video :
https://www.youtube.com/watch?v=urTwxelK-Xc
Please let me know if this works for you.Thanks,
Ankita
Hi powerbiexpert22, Hope you are doing good!
In latest version of Power BI, you can create many to many relationship.
If you want to avoid many to many relationship then you can create brige table either using DAX or through Power Query editor.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!Hi anmolmalviya05 , how to create bridge table with two columns as shown in example i gave?
Hi powerbiexpert22 ,
I create two tables and you can see both of them have ProductID column.
If only the ProductIDs in these two tables are linked, there will be warnings and Many-to-Many will easily cause the model to report errors.
Which can be solved by using bridge tables. Then I create a bridge table.
You end up with two one-to-many joins of two tables that just had a many-to-many relationship via the ProductID column in the bridge table.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
