Forum Discussion
Relationship error between 3 tables
Hi Team,
I'm trying to create a table visual in powerbi where the data has tobe taken from 3 tables. I have "PersonID" Column present in all these 3 tables on which I have created relationship.
When I try to bring columns from these 3 talbes it gives "no relationship between table" error. Can anyone let me know how I can resolve this ?
11 Replies
Anonymous , Not very clear, The table having the unique person ID that should be joined with the other two tables. with One to Many Join.
Can you share a sample pbix after removing sensitive data.
amitchandak Yes amit. The Table1 has unique IDs of Person ID. and its joined with other tables with one to many relationship.
When I create a table visual with only values from Table1 and Table2 OR Table1 and Table3, it works.
But when i try to add values to table visual from all of these 3 tables it says relationship doesnt exists.
Anonymous , Got it. In this case, you can not have un summarized columns from both Table2 and Table 3. You need to take aggregation on columns from one of the tables(Table2 or Table3) when all three is used.
Hi Anonymous ,
If allowed, you can set the relationship between Table1 and Table2 or Table3 to be many-to-many. If you cannot modify the relationship among tables, you can merge Table1 with Table2 or Table3 in Power Query Editor.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.Best Regards,
WinnizIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
PaulDBrown yes. Thanks Paul. I tried with some dummy data which actually worked. I think i have issues with my entire model which is leading this error. I will try to amend my model to see if that the issue.
