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

Antonio Santos 1 Reputation point
2021-05-24T16:04:57.15+00:00

Hi,
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

99164-capturar.png

Here's the output:
99232-capturar.png

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
    2021-05-24T16:37:04.103+00:00

    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..