Relationship Issue with 4 tables

[mbasha_123]

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

[Anonymous · Accepted solution]

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.

[AliceW]

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?