Missing Data after creating a relationship

[rishabh770]

Hello All,

I have created a relationship between the two tables using the serial number. The serial number column in both the tables have text data type and contains both text and numerical values (few serial numbers are like SHA5678 and few like 129876). After creating the relationship the serial numbers with only numerical values have disappeared from the visualisations. 

I have also compared the values in both the tables (they are exactly same).

Can someone help me in resolving this issue?

Thanks 

[amitchandak · Accepted solution]

@rishabh770 , This means One side of the table is missing the serial numbers or Many size have null.

This can be because of spaces.  You can use trim and clean in power bi in join columns

Power Query Trim and Clean : https://youtu.be/NRYPsCnS0w4