Forum Discussion

mbasha_123's avatar
mbasha_123
Frequent Visitor
2 years ago
Solved

Relationship Issue with 4 tables

Hi Team, I have loaded the total 4 tables into the Power BI Desktop Application and have created the relationship below  it is showing the data til when I was added the 1,2,and 3 tables then ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi mbasha_123 ,

     

    According to your screenshot, I think your issue should be caused by relationship.

     

    Relationship 1 :

    'Customer_Detail_Customer_Details'[Column] → ‘Customer_Details_Platform'[Column] → ‘CustomerMatser’[Column]

    → ‘Product_or_Module’[Column]

     

    Relationship 2 :

    'Customer_Detail_Customer_Details'[Column] → ‘Product_or_Module’[Column]

     

    We can see that 'Customer_Detail_Customer_Details' table can filter ‘Product_or_Module’ in two relationship directions. So Power BI will throw this error.

    I can reproduce this error on myside.

    I think you may get error when you use unsummarize function in table4 column. You relationship doesn't support the visual to expand with data in full four tables. 

    For reference: Relationship troubleshooting guidance - Power BI | Microsoft Learn

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi mbasha_123 ,

 

According to your screenshot, I think your issue should be caused by relationship.

 

Relationship 1 :

'Customer_Detail_Customer_Details'[Column] → ‘Customer_Details_Platform'[Column] → ‘CustomerMatser’[Column]

→ ‘Product_or_Module’[Column]

 

Relationship 2 :

'Customer_Detail_Customer_Details'[Column] → ‘Product_or_Module’[Column]

 

We can see that 'Customer_Detail_Customer_Details' table can filter ‘Product_or_Module’ in two relationship directions. So Power BI will throw this error.

I can reproduce this error on myside.

I think you may get error when you use unsummarize function in table4 column. You relationship doesn't support the visual to expand with data in full four tables. 

For reference: Relationship troubleshooting guidance - Power BI | Microsoft Learn

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.