Forum Discussion
Relationship error between 3 tables - Help
Hello team, I have a doubt and I need help. I made a summarized example of my problem, I have 3 tables where I created a key in each one and created a table with SUMMARIZE.
from the relationship I would like to get information from the 3 tables, but when placing the fields it is giving a relationship error
----- > Test.pbix
I can't understand where the relationship error is. Thanks for the help
Hi Spotto ,
Can't display the data because Power BI can't determine the relationship between two or more fields.'
You are trying to use two or more fields from tables that are not related. You need to remove the unrelated fields from the visual and then create a relationship between the tables. Once you have done this change, you can add the fields back to the visual. Refer: Create and manage relationships in Power BI Desktop
You can refer this simliar issue:
Error: Can't determine relationship between fields
Solved: Can't display the data because Power BI can't dete... - Microsoft Power BI CommunityBest Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Spotto ,
Can't display the data because Power BI can't determine the relationship between two or more fields.'
You are trying to use two or more fields from tables that are not related. You need to remove the unrelated fields from the visual and then create a relationship between the tables. Once you have done this change, you can add the fields back to the visual. Refer: Create and manage relationships in Power BI Desktop
You can refer this simliar issue:
Error: Can't determine relationship between fields
Solved: Can't display the data because Power BI can't dete... - Microsoft Power BI CommunityBest Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.