BenchMark Quizzes by MDFT Pro

Combine Tables In Power BI For Simpler Data Models

You create a dataset at MDFT Pro using multiple data sources with similar tables. The academy wants to simplify the data model to make creating visuals easier for trainers and students.

You need to reduce the number of tables to simplify the data model. Which method should you use to combine the tables for each scenario?

Choose all correct answers from the options below.

Explanations for each answer:

You should use Combine Files for folders containing JSON documents with the same structure. is correct. Combine Files is used to combine files of the same type and structure in a folder into a single table.
You should use Merge Queries for combining multiple tables with a common key between them. is correct. Merge Queries combines tables using a shared key, similar to a SQL JOIN.
You should use Append Queries for combining multiple tables with the same columns containing data for each month is correct. Append Queries concatenates rows from tables with the same structure into a single table.
You should use Merge Columns for combining multiple tables with different columns is incorrect. Merge Columns combines columns within a single table, not tables with different columns.

Learn more about combining tables in Power BI:

Power BI Append and Merge

Exam Preparation Quiz

Combine Tables In Power BI For Simpler Data Models