Data Quality Issue

[VulcanPromance]

I have 2 tables.

Employees and Licenses

When I try to do a visual of those using The ID and Licensetype from License Table and Name, Company and Surname from Employees table, then suddenly a couple of users lost information.. If I do a full visual from Employees Table, and try to add just the LicenseType from Licenses to that presentation, then all information is lost.  Its only for a very few users this happens and I have no idea why..

[HotChilli]

This looks like powerbi can't match up ID = 1 between the two tables.

Check the data types you have on the ID field in both tables.  This can happen if there is a mismatch (at least one may be text and may have additional hidden chars, spaces etc).

[VulcanPromance]

@HotChilli 

Both columns are Text (cause the actual data is like t505050 or ttggt or similar..)

The system that contains the data also creates an account using the CorporateID from Employee to create Account so they will stay equal. But to be sure I checked 2 of the records.. no spaces before or after on either.

[HotChilli]

Powerbi thinks the fields are different.  You'll have to debug the issue.  Try going into Power Query and cleaning the data with Trim, Upper etc.

Experiment with merging queries in Power Query to see if it can join on the fields.