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:
this proposal changes the underlying model, and the granularity of the fact table which i was hoping to avoid.
Read the announcement for more information!
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Get an overview of the events and great community content from November.
Find out where you can attend!