Forum Discussion
Frede
Helper I
Helper IIssue with circular relationships
HI! A bit long so please bear with me. I have a Power BI data model that looks like below. All relationships are single direction and move in the direction of the arrow from ONE to MANY (end of ...
v-jiascu-msft
Microsoft Employee
Microsoft EmployeeHi Frede,
Can you share a sample file, please? Only a small file is needed that can show your model.
1. That depends on your data model. We can't choose which path to use. But how we select the columns determines the behavior of the Power BI. For instance, there are three [AgenceName] in three different tables. The result depends on which one we choose.
2. Just see from your image, there aren't any loops. Because the [Cross Filter Direction] is also the key part of the relationship of Power BI. Please refer to the snapshot.
BTW, the [Event] table and the [BookingWithAgency] seem to have similar contents.
Best Regards,
Dale