Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
mehaboob557
Resolver IV
Resolver IV

Need to manage many to many replationship

Hello all,

 

I have 4 tables proposal, prod, prodModule, addon. All are having 3 columns same like, proposlaId, quotenum, CrId.

 

ProposalId's can have multiple w.r.t versions. 

 

for ex:

     Proposal table

         proposalId  |  version 

              pre1              0.1

              pre1              1.2

     Prod table

         proposalId  |    abc     |....

              pre1              a

              pre1              xyz

   prodModule table

         proposalId  |    def |... .

              pre1              a

              pre1              xyz

 

 

I want to make relation ship from proposal table to prod with ProposalId (many to many).

same from prod to prodModule and prodModule to some other table.

 

How can i achieve this. 

 

I am getting the below error

 

relation.PNG

 

Please help me how can i able to achieve this, as my visulas will be based on these relations.

 

Thanks in advance.

1 ACCEPTED SOLUTION

can you write a query from MySql that gets the valid combinations of ID's from both of your tables?



I hope this helps,
Richard

Did I answer your question? Mark my post as a solution! Kudos Appreciated!

Proud to be a Super User!


View solution in original post

5 REPLIES 5
richbenmintz
Solution Sage
Solution Sage

you require a many to many bridge table in between proposal and proposal_product. the bridge table would contain all valud combinations of the id's in the tables proposal and product_proposal. 

 

Once you have the bridge you would create 1->* relationships between each table and the bridge with filter direct set to both.

 

Hope that helps.

 

Richard



I hope this helps,
Richard

Did I answer your question? Mark my post as a solution! Kudos Appreciated!

Proud to be a Super User!


Hi @richbenmintz

 

Thank you fro the response.

 

I am new here. Please suggest me how can i create many to many relationship Bridge

what is the source of your data? are you able to right sql to derive the bridge or do you need to create the bridge table in powerbi?



I hope this helps,
Richard

Did I answer your question? Mark my post as a solution! Kudos Appreciated!

Proud to be a Super User!


I am fetching my data from MySQL.

 

I need to create many to many bridge in Power BI so that i can create visulas

can you write a query from MySql that gets the valid combinations of ID's from both of your tables?



I hope this helps,
Richard

Did I answer your question? Mark my post as a solution! Kudos Appreciated!

Proud to be a Super User!


Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.