BenchMark Quizzes by MDFT Pro

Unify Data From Different Sources Using Power Query

You are using Power Query Editor at MDFT Academy to import data for a single business entity from different data sources with different schemas. All sources share a common ID, and you want to create a unified view for reporting.

You need to unify the data for use as a slicer in your report. Which feature should you use to achieve this goal?

Choose the correct answer from the options below.

Explanations for each answer:

Merge queries is correct. Merge queries is used to unify data from different sources with a common ID, creating a single dimension table for filtering and slicers.
Append queries is incorrect. Append queries is for combining tables with similar schemas, not for unifying entities from different sources.
Group by is incorrect. Group by is used for grouping data within a single table, not for unifying tables.
Merge columns is incorrect. Merge columns combines columns within a single table, not for unifying tables from different sources.
Combine Files is incorrect. Combine Files is for combining files with the same schema, not for unifying tables from different sources.

Learn more about merging queries in Power BI:

Power Query Merge

Exam Preparation Quiz

Unify Data From Different Sources Using Power Query