In Power Query, what does the ‘Merge Queries’ operation do?

Question

Power BI — Medium

In Power Query, what does the ‘Merge Queries’ operation do?

Accepted Answer

The 'Merge Queries' operation in Power Query combines two tables based on matching columns. This is similar to a SQL JOIN, where rows from both tables are merged into one. The correct answer, B, is right because it accurately describes this process. Options A, C, and D are incorrect as they describe different operations, such as appending rows or removing duplicates.