Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I was given a table and two columns on the table have a many to many relationship. I know that I can create two new tables and create the relationships between them and the original table. But I would like to know Powerbi Desktop can allow me to create a many-to-many relationship between two columns in the same table. This would be a straight and simplest solution.
Solved! Go to Solution.
HI @Curious1_209,
AFAIK, current power bi does not support multiple active relationship keys between two tables. (power bi will use one major relationship to mapping and analysis table records, the others will turn to inactive)
Did you mean the standalone many to many relationships on two columns or the combo relationship based on multiple fields?
If you mean the second one, you can take a look at the following link to know how to create relationships based on multiple fields.
Relationship in Power BI with Multiple Columns - RADACAD
Regards,
Xiaoxin Sheng
HI @Curious1_209,
AFAIK, current power bi does not support multiple active relationship keys between two tables. (power bi will use one major relationship to mapping and analysis table records, the others will turn to inactive)
Did you mean the standalone many to many relationships on two columns or the combo relationship based on multiple fields?
If you mean the second one, you can take a look at the following link to know how to create relationships based on multiple fields.
Relationship in Power BI with Multiple Columns - RADACAD
Regards,
Xiaoxin Sheng
Separating these columns out into their own dimension tables seems to be the right approach here. Hard to tell without sample data and more context.
"straight and simple" and "many to many" do not go well together.
User | Count |
---|---|
85 | |
81 | |
66 | |
62 | |
53 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |