cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

many to many dimensions - "Cant display the visual"

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.

Capture.JPG

 

 

 

2 REPLIES 2

Re: many to many dimensions - "Cant display the visual"

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.

Re: many to many dimensions - "Cant display the visual"

thanks @evandrocunico 

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

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)