Relationship error between 3 tables - Help

[Spotto]

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

[v-yangliu-msft · Accepted solution]

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 Community

Best Regards,

Liu Yang

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