Forum Discussion
Bridge Table Failure
I'm encountering a challenge while attempting to address a many-to-many relationship between two tables using a Bridge table in Power BI. Despite establishing one-to-many relationships from the Bridge table to the other two tables, I find myself unable to display columns from all three tables simultaneously. Instead, I can only choose columns from the Bridge table and one of the other two tables, leading to a recurring "can't build relationship" issue. My goal is to showcase columns from all three tables simultaneously. Any guidance on resolving this issue would be greatly appreciated. Need Help
- Anonymous2 years ago
I have got the solution to the same, I was trying to get two unsummarized data in a table which is not possible.
2 Replies
- MusadevResolver III
Share the 2 tables and also the bridge table. Thanks
- AnonymousNot applicable
I have got the solution to the same, I was trying to get two unsummarized data in a table which is not possible.