As the data analyst of MDFT Pro, a well-known training agency, you are building a course catalog dataset in Power BI. You have two CSV files named Products and Categories.
The Products file contains the following columns:
- ProductID
- ProductName
- SupplierID
- CategoryID
The Categories file contains the following columns:
- CategoryID
- CategoryName
- CategoryDescription
From Power BI Desktop, you import the files into Power Query Editor.
You need to create a Power BI dataset that will contain a single table named Product. The Product table will include the following columns:
- ProductID
- ProductName
- SupplierID
- CategoryID
- CategoryName
- CategoryDescription
How should you combine the queries, and what should you do on the Categories query?
Append is incorrect. Append stacks rows vertically, which would not add Category columns to the Product table.
Transpose is incorrect. Transpose swaps rows and columns, which would not combine the two tables on a common key.
Merge is correct. Merge joins the two queries on CategoryID, combining the columns from Categories into the Products query to create a single Product table with all required columns.
Disable the query load. is correct. Disabling the query load on Categories prevents it from being loaded as a separate table in the model while keeping it available for the merge transformation.
Exclude the query from report refresh is incorrect. Excluding from report refresh still loads the query into the model as a separate table, which is not desired.
Delete the query. is incorrect. Deleting the Categories query would remove it entirely, but you still need its data during the merge transformation.