Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
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.
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?