Why are related data not showing up despite the reference columns/values match in Power query Merge?

Antonio Santos 1 Reputation point

I have joined these two tables, related them by a PO number. The PO number exists in both of the tables, but the left one shows most of its values as null, despite the PO number is there?
Clumn Name is PEDIDO


Here's the output:

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
34,907 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Lz._ 8,981 Reputation points

    Hi @Antonio Santos

    I would suspect trailing space(s) in the key column ([PEDIDO]) either in one of the tables or in both

    To check (do this on both tables): when you're the Power Query Editor > Right-click [PEDIDO] > Transform > Trim. Then try to merge again..