Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Please help me how can i able to achieve this, as my visulas will be based on these relations.
Thanks in advance.
Solved! Go to Solution.
can you write a query from MySql that gets the valid combinations of ID's from both of your tables?
Proud to be a Super User!
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
Proud to be a Super User!
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?
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?
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |