Relationship issue using a bridge

[ChrisN32]

Hi all,

I can't display columns from 2 tables next to each other in a visual, I get the "Can't display the data because Power BI can't determine the relationship between two or more fields". All the relationships are matching 100% (checked with Merge Query in Edit queries).

What am I missing?

Sample model 

Thanks in advance!

Chris

[ChrisN32]

Like magic, thanks again Amit! I owe you another coffee.

[amitchandak · Accepted solution]

@ChrisN32 , both Table on Many side, can not have un summarized column in a visual.

Please check the attached file after signature, for changes