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.
Im trying to do many to many dimensions in powerbi.
I have DimThirdPartyNumber. There can be many of these per entry in DimUser. Each user has many reports in FactReports. I am displaying the data in a table, not using any measures.
I can add attributes from DimUser & DimThirdPartyNumber to my table without issue.
When i add an attribute from DimReport however, my table says "cant display the visual.
The only way i can get this to work is with many to many relationship enabled betweeen DimUser, DimThirdPartyNumber & the bridging table.
I have two questions:
1. Why doesnt this work without many to many enabled?
2. is there a solution to use this without many to many?
Screenshot is below, and link to sample pbix is here
thanks for any help or expertise.
Hi, try this:
Delete relation between User third party id bridge and dim users
Create a new relation: User third party id bridge - userid with fact reports - userid
For your reference:
https://www.sqlbi.com/tv/different-types-of-many-to-many-relationships-in-power-bi/
Regards.
thanks @evandrocunico
this proposal changes the underlying model, and the granularity of the fact table which i was hoping to avoid.
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |