cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ksbiexpert06 Visitor
Visitor

Power BI "An Active relationship already exists between tables" Deactivate the existing relationship

Hi , I have a complex data model and some of the tables has multiple joins between two tables and i am not able to define multiple joins between the two tables. I am getting an error "Power BI "An Active relationship already exists between tables" Deactivate the existing relationship first".. Below is a quick example and not the actual tables. Its allowing me only to activate only one relation ship ..? Any suggestion

 

multiplejoin.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
KHorseman Super Contributor
Super Contributor

Re: Power BI "An Active relationship already exists between tables" Deactivate the existin

You can only have one active relationship between two tables. You can however create as many inactive relationships as possible. It's easiest to do this through the Manage Relationships button on the Modeling tab in the ribbon. Once you've added them, you can write measures to reactivate them for specific calculations with the USERELATIONSHIP function. In cases where you need more than one relationship between the same two tables, I recommend making none of them active, simply toggle them back on with USERELATIONSHIP.


Did I answer your question? Please mark it as a solution.

Proud to be a Datanaut!

View solution in original post

2 REPLIES 2
KHorseman Super Contributor
Super Contributor

Re: Power BI "An Active relationship already exists between tables" Deactivate the existin

You can only have one active relationship between two tables. You can however create as many inactive relationships as possible. It's easiest to do this through the Manage Relationships button on the Modeling tab in the ribbon. Once you've added them, you can write measures to reactivate them for specific calculations with the USERELATIONSHIP function. In cases where you need more than one relationship between the same two tables, I recommend making none of them active, simply toggle them back on with USERELATIONSHIP.


Did I answer your question? Please mark it as a solution.

Proud to be a Datanaut!

View solution in original post

Super User
Super User

Re: Power BI "An Active relationship already exists between tables" Deactivate the existin

Hi @ksbiexpert06,

In PBI you can only have one active relationship between tables, although you can have more than one relation between tables only one will be active.

The option here is to create dimension tables with unique values and pass the relationships for both tables trough those dimension tables creating a star schema.

Regards,
Mfelix


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,637)