Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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's avatar
    Anonymous
    4 years ago

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

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

 

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

 

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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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