Forum Discussion

Databasic's avatar
Databasic
Regular Visitor
1 year ago
Solved

Model relationships breaking unexpectedly when visualizing Planning table columns in Power BI

Hi We are going to change ERP system and I have to alter my data so we can upload it in the right format to our ERP system. Here’s my current setup: All relevant columns are formatted as T...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    1 year ago

    Hi Databasic  - Only keep Name → Planning and Name → RM_Film relationships as single-directional (one-to-many, from Name to Planning/RM_Film). That’s usually safest.

     

    When both are set to bidirectional, Power BI may struggle to resolve filter propagation, especially when you try to pull data into a single visual that includes columns from all three tables errors like , ambiguous filter paths. Avoid bidirectional joins unless truly needed.

    suggest you, make them single-direction from Name → Planning and Name → RM_Film.Use that table for your ERP export visuals/reports — reliable and isolated from model quirks.If needed, use slicers from Name or Fixed tables to make dynamic test versions.

    Bidirectional relationships and ambiguity in DAX - SQLBI

     

    Hope this helps.

     

     

v-pnaroju-msft's avatar
v-pnaroju-msft
Community Support
1 year ago

Thankyou, rajendraongole1, for your response.

Hi Databasic,

We appreciate your question on the Microsoft Fabric Community Forum.

Based on my understanding of the issue, please find attached a screenshot and a sample PBIX file that may assist in resolving the matter:

We hope the information provided helps to resolve the issue.
Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.

Thank you.