Forum Discussion
Helper IMultiple connecting relationships
Hello,
What you are trying to do is similar to handling role playing dimensions within power bi which is not possible due to the limitation of only 1 active join (relationship)
The ugly solution is to import "Resource_Data_Table" twice with different names into Power BI desktop, as if they are separate tables. Then you can an have active relationship to each table
I came across the following alternative method, in which a table can be 'cloned' within power bi, so you can clone Resource_Data_Table to a different name and use it for the 2nd join (relationship)
http://biinsight.com/role-playing-dimensions-in-power-bi/
Advocate IIHello,
What you are trying to do is similar to handling role playing dimensions within power bi which is not possible due to the limitation of only 1 active join (relationship)
The ugly solution is to import "Resource_Data_Table" twice with different names into Power BI desktop, as if they are separate tables. Then you can an have active relationship to each table
I came across the following alternative method, in which a table can be 'cloned' within power bi, so you can clone Resource_Data_Table to a different name and use it for the 2nd join (relationship)
http://biinsight.com/role-playing-dimensions-in-power-bi/
Helper Ithe limitation is truly a hindrance to what we want to show.
what I just did is to create a report in excel that shows the Platform Engineers without the Owners.
and uploaded it in Power BI
then connected to the bridge table to create the relationship with the other tables.