many to many dimensions - "Cant display the visual"

[wilson_smyth]

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.

[evandrocunico]

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.

[wilson_smyth]

thanks @evandrocunico 

this proposal changes the underlying model, and the granularity of the fact table which i was hoping to avoid.