Forum Discussion
Solved
Missing Data after creating a relationship
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 value...
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
amitchandak
Super User
Super Userrishabh770 , 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