Forum Discussion
Data issue between tables
Well, Power BI creates those relationships automagically most of the time. You need to inspect your data model and the data. So, for example of how this could happen. Suppose you have an employee id and that is what Power BI decided to make the relationship on. Except that your data is bad and you have the same employee id for 3 different people in one of the tables. Well, there you go. So, I would start by looking at your data model and seeing what columns the relationship is built on. You just need to double-click the relationship or click on the relationship and see what columns get highlighted.
Would need to understand the data better. Probably something related to a relationship. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Greg_Deckler Thanks Greg - I am not sure how it can be a relationship as I just created the tables from the data and every other link when clicking on the individuals works perfectly.....Jessica matches with Jessica, Dayle matches with Dayle. Its only when I click on Nick that for some reason it highlights 3 different people. I am not sure I am going to be able to solve it as I have limited knowledge at the moment and am going to have to learn alot more before I am able to resolve this kind of issue.
Thanks anyway.
Well, Power BI creates those relationships automagically most of the time. You need to inspect your data model and the data. So, for example of how this could happen. Suppose you have an employee id and that is what Power BI decided to make the relationship on. Except that your data is bad and you have the same employee id for 3 different people in one of the tables. Well, there you go. So, I would start by looking at your data model and seeing what columns the relationship is built on. You just need to double-click the relationship or click on the relationship and see what columns get highlighted.