Question

In Power Query, you are building a fact table by combining an Orders query with a Customers query. Every order must remain in the result even when no matching customer record exists, and you want to bring in the customer's Region column. Which merge join kind should you use, and against which query?

Accepted Answer

Perform a Left Outer join with Orders as the first (left) query and Customers as the second query

Answer

Perform an Inner join with Orders as the first (left) query and Customers as the second query

Answer

Perform a Right Outer join with Orders as the first (left) query and Customers as the second query

Answer

Perform a Left Anti join with Orders as the first (left) query and Customers as the second query