Data Model Viewer can read values but Data Manager can't?

[Huxleys]

Hi. I have a strange issue where an ID field is not associating correctly. The association is being made as the column names match, but the data is being misread. I have two tables named InvoiceID, one in fact.Invoices table and one in dim.Offer table.

Here, the data model viewer can read the IDs and the Tag. However, the data manager is not reading the InvoiceID as per the next screenshot:

Worth noting that the fact.Invoices table grabs data from a QVD while dim.Offer is from SQL, however the invoices do have matching records in both tables - I'm just not sure why the data manager is presenting the IDs and "?" in Data Manager and failing to correctly associate the fields in both tables.

Any help on this would be greatly appreciated!

[Huxleys · Accepted solution]

Solved it - SQL values had some sneaky leading/trailing spaces - all fixed with an ltrim and rtrim 😑