Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
PhilaeRosetta
New Member

Many relationship on dimensionto be activate

Hi,

 

I have an issue.

 

I have a fact table which contains two persons: The holder of a contract and eventually his/her partner.

They are both linked to a person table dimension...

 

When I link both to my dimension table with power pivot I can't activate both relationship:

PhilaeRosetta_0-1669813912585.png

 

How can I manage that? Do I need to make two versions of the dimension table?

 

Thanks for answers.

1 REPLY 1
amitchandak
Super User
Super User

@PhilaeRosetta , seem like bi-directional relation or over-model creating loops of two paths and the relationship is inactive. check the model and try to resolve that

 

if you have a valid inactive then we can use userelationship

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.