HOTSPOT 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 will table includes the following columns:
• ProductID
• ProductName
• SupplierID
• CategoryID
• CategoryName
• CategoryDescription How should you combine the queries, and what should you do on the Categories query? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Step Sequence / Reordering Question
Add and arrange the steps in the correct execution order.
Available Steps (13)
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 will table includes the following columns:
ProductID
ProductName
SupplierID
CategoryID
CategoryName
CategoryDescription How should you combine the queries, and what should you do on the Categories query? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Your Ordered Steps (0 of 2)
No steps added yet. Click "Add to Sequence" from the available steps above.
Explanation
Hotspot Solution:
Recommended Community Solution:
Answers: - Combine the queries by performing a: Merge (You need to join Products with Categories on CategoryID to bring in CategoryName and CategoryDescription.) - On the Categories query: Disable the query load (You don’t need the Categories table in the final model, but you still need it for the merge. Disabling load keeps it available in Power Query without loading it into the data model.)
Community Discussion
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
1
Firstly merge the queries and then disable the query load.
1
Answer: Merge Disable the query Load
3
* Answers: - Combine the queries by performing a: Merge (You need to join Products with Categories on CategoryID to bring in CategoryName and CategoryDescription.) - On the Categories query: Disable the query load (You don’t need the Categories table in the final model, but you still need it for the merge. Disabling load keeps it available in Power Query without loading it into the data model.)
