Forum Discussion
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 after if I am trying to add the 4 table with the relationship (Many to One) and Cross filter direction have tried with Single and Both
it is throwing the error like below
Can any please help me on this
Regards,
PBI User
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
It's normal that it's throwing an error.
May I suggest you either not use the many-to-many? Or that you build a 'snowflake' like model, with relationships streaming from a center table?
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
