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

"Can't create direct active relationship" - even though it was already active

I'm having an odd problem with Power BI Desktop.

 

I currently have an active relationship between two tables. Everything is working fine.

 

active-relationship.png

 

 

However, when I make the relationship inactive, then try to make it active again (without changing anything else), I get this error:

inactive-relationship.png

 

I know it's not Salary Bands table that's the issue, as this is a simple table that is only connected to the JobOrders table, nothing else. Additionally, when I make that relationship inactive, it throws the same error with a different relationship.

 

Couple other notes:

- The reason I'm doing this is because initially I was trying to switch the relationship to another column in the JobApplications table that has the exact same IDs, and remove the current column. I couldn't figure out why it wasn't allowing me to create an active relationship on this new column, and by testing the above I realised it's not an issue with that column, it's giving me this error even on the existing column, just by switching the relationship to inactive and back to active again.

 

- I know I can use USERELATIONSHIP but our data model is very complex and this would involve making a number of measures and other changes. And of course this relationship should be able to be active, since it was before.

3 REPLIES 3

Re: "Can't create direct active relationship" - even though it was already active

There could be a possible circular relationship between the tables. Perhaps a screenshot of the relationship view, to see how the tables relationships are flowing, might help us understand this better.

kyle Frequent Visitor
Frequent Visitor

Re: "Can't create direct active relationship" - even though it was already active

Hi @nikhilmekala

 

I can (see below) but as I mentioned our model is fairly complex, and also the point is that it is working as an active relationship, however whenever I make it inactive, I cannot make it active again, which is bizarre.

 

model-snapshot.png

 

I've highlighted the relationship in question (currently it's active in the screenshot). You can see the Salary Bands table is only linked to JobOrders, so that shouldn't be a problem even though the original error message says that there will be ambiguity with this table if I were to re-activate the relationship between JobApplications and JobOrders.

 

Again this is just a snapshot because we have 30+ tables in our model.

Community Support Team
Community Support Team

Re: "Can't create direct active relationship" - even though it was already active

@kyle,

 

You may check if the following post helps.

https://community.powerbi.com/t5/Desktop/Bi-directional-cross-filtering-ambiguity/td-p/119890

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 263 members 2,978 guests
Please welcome our newest community members: