Question
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 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?
Explanation
Combine the queries by performing a: Merge, joining Products to Categories on CategoryID to add CategoryName and CategoryDescription as columns. Append would stack rows rather than add columns, and transpose does not combine queries. On the Categories query: disable the query load so the dataset contains only the single Product table. Deleting the query would break the merge that depends on it, and excluding it from report refresh would leave category data stale.
