Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
RJOttenheim
Resolver I
Resolver I

Bridge table not working

To avoid the N:M relationship i used a bridgetable as below figure shows.

Hoewever when i can only select from left or right 2 tables. But if i want to show fields from both outer tables i get "Cant determine the relationships between fields" It doesnt matter what i do with bidirectional filtering. I cannot

 

RJOttenheim_0-1643896574870.png

 

When i use the many to many i can select from both tables

 

RJOttenheim_1-1643896816536.png

 

Can anyone explain why this is happening ?

 

Regards

2 ACCEPTED SOLUTIONS

I dont want a key field in my visual. Next to that. I think that Bridge Tables should be hidden tables. They are there so i can avoid N:M relationships.

 

Since it is not working for me i switches to N:M relationships.

 

Thanks anyways

View solution in original post

RJOttenheim
Resolver I
Resolver I

Issue was cause by a text measure. Thanks for you help.

View solution in original post

5 REPLIES 5
RJOttenheim
Resolver I
Resolver I

Issue was cause by a text measure. Thanks for you help.

v-eqin-msft
Community Support
Community Support

Hi @RJOttenheim ,

 

Based on my test, please do not drag the related Key field to visuals:

Eyelyn9_0-1644386141544.png

 

If you want, you need to use the Key field from the Bridge table , as shown below:

Eyelyn9_1-1644386222741.png

 

Refer to:

How to Join Many to Many with a Bridge Table in Power BI | Seer Interactive

Looking at Power BI Many to Many

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I dont want a key field in my visual. Next to that. I think that Bridge Tables should be hidden tables. They are there so i can avoid N:M relationships.

 

Since it is not working for me i switches to N:M relationships.

 

Thanks anyways

Anonymous
Not applicable

try using single directional and one to many

As i said. Changing directions doesnt work.

Single Directional and one to many is what the picture shows.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.