Forum Discussion
Can't determine relationship between the fields when trying to link multiple tables
Hi JohnBerk ,
'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
In this case, [AddressLine1], [ClientSubId] and [EmailAddress] doesn't have any relationship such as one-to-one or one-to-many. They can just both filtered by 'Client'[ClientId].
You can refer this simliar issue: Error: Can't determine relationship between fields
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Here is the error when I try and add information from the third table. as soon as I check emailaddress teh error occurs.
here is the relationship visual.
here is the detail on one of the edit relationships. the other two are setup the same fashion
I appreciate you reply. I have look at the relationships I'm trying to setup here versus some sample dashboard and do not see what's different to make mine not work.
Community SupportHi JohnBerk ,
'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
In this case, [AddressLine1], [ClientSubId] and [EmailAddress] doesn't have any relationship such as one-to-one or one-to-many. They can just both filtered by 'Client'[ClientId].
You can refer this simliar issue: Error: Can't determine relationship between fields
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.