Natural Left join not capturing all the data

Hi Anonymous ,

According to your description, I create a sample, and merge queries use Left Outer join kind(Table2, Table1).

After expand table, as 002 is the only one in Table2 but not in Table1, it goes to the last line by rules. I doubt if it got to the last line you didn't find it.

I attach my sample below, please go to Power Query applied steps to check.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.