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 ChampionHi JohnBerk - the first thing that pops out is you might want to consider storing the IDs as Text rather than numbers so they don't get formatting in exponential notation.
The other thing would be to consider turning on bi-directional filtering on all of the relationships, but I would mess with the storage of the IDs first. PowerBI will often acknowledge that it was able to create a relationship, when in practice the columns really aren't matching (you see this often with a date+time joined to a date - they're not the same value).
Hope this helps
David