Microsoft
PL-300 · Question #360
You use Power Query to import two tables named Order Header and Order Details from an Azure SQL database. The Order Header table relates to the Order Details table by using a column named Order ID in
The correct answer is A. Merge queries. https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data
Submitted by eva_at· Apr 18, 2026
Question
You use Power Query to import two tables named Order Header and Order Details from an Azure SQL database. The Order Header table relates to the Order Details table by using a column named Order ID in each table. You need to combine the tables into a single query that contains the unique columns of each table. What should you select in Power Query Editor?
Options
- AMerge queries
- BCombine files
- CAppend queries
How the community answered
(30 responses)- A83% (25)
- B3% (1)
- C13% (4)
Explanation
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data
Community Discussion
No community discussion yet for this question.