cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

Accepted Solutions
Highlighted
Solution Specialist
Solution Specialist

Re: Need to manage many to many replationship

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

View solution in original post

5 REPLIES 5
Highlighted
Solution Specialist
Solution Specialist

Re: Need to manage many to many replationship

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

Highlighted
Resolver IV
Resolver IV

Re: Need to manage many to many replationship

Hi @richbenmintz

 

Thank you fro the response.

 

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

Highlighted
Solution Specialist
Solution Specialist

Re: Need to manage many to many replationship

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?

Highlighted
Resolver IV
Resolver IV

Re: Need to manage many to many replationship

I am fetching my data from MySQL.

 

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

Highlighted
Solution Specialist
Solution Specialist

Re: Need to manage many to many replationship

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

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors