Forum Discussion
Multiple active relationship workaround
Is there a work around for Power BI not support multiple active relationships? I have a situation where my Fact Table is related to another table in a one-to-many relationship. The fact table bein...
To have a double active relationship between two tables:
1/ import the first table (e.g. First)
2/ import the second (e.g. Second)
3/ make the first relationship between tables 1 and 2
4/ import table 1 again (will be called First (2) )
5/ make the other relationship between 2 and your new 1 - First (2) -