Active Relationship Setup

[amedvedev]

Hello,

  I have a schema that looks like this:

When I try to create a visual with columns from both the values and dim tables, I get the following error:

I can create an active relationship using the drag-and-drop functionality:

This resolves my issue. However, when I try to create the relationship using the "Manage Relationships" button, I am getting this warning:

Me and my team set relationships programatically by hitting Power BI endpoints, and we are running into the issue that you see in the screenshot from when we use the "Manage Relationships" button. Does anyone have any insight on how these two methods of setting relationships are different?

[ribisht17]

Hi @amedvedev 

Please check

1.https://www.vivran.in/post/understanding-ambiguity-in-power-bi-data-model

2. https://community.fabric.microsoft.com/t5/Desktop/You-Can-t-create-a-direct-active-relationship-two-...

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users