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.
Is it possible to create many to many relationships? Or do I create it trough an intermediate table like in Analysis Services?
Thanks!
Solved! Go to Solution.
To be honest, I was referring to this article:
You should not need to write any special DAX to get the N:N relationship working in Power BI Desktop. You just need to create bi-directional relationships to the bridge table. The bridge is necessary, but as long as you have all bi-directional relationships in the chain of relationships between two tables, all filter context will flow appropriately between them.
For in-file models it works (includes imports to SQL)
For AS Tabular 2014 it does not work.
For AS MD I do not know (they work out of the box with the MD server, but I do not know how PBI handles it)
For AS Tabular 2016 it should work.
Nowadays I am interested in Multidimensional and in-file models (I understand that you refer this as create your own model in Power BI Desktop from importing differente files, is it?)
In this case, in-file models, I can not view the option Many to Many in the option "Cardinality" in a relationship options...
To be honest, I was referring to this article:
Ok. So, as I can see, it has to be modeled with an intermediate table (like in SSAS), as then use DAX functions to get the correct functionality.
Thanks!
You should not need to write any special DAX to get the N:N relationship working in Power BI Desktop. You just need to create bi-directional relationships to the bridge table. The bridge is necessary, but as long as you have all bi-directional relationships in the chain of relationships between two tables, all filter context will flow appropriately between them.
Could you show as a demo of a bi-directional relationships? I am new with Power BI and would like to understand a little bit more about how you would go about creating such a relationship?
Hi @greggyb, When I tried to make a bi directional relationship it is giving me a circular dependency detection! I think this is because the table contain calculated columns.. What can I fix this problem?
Thanks greggyb!
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |