Question

You are building a Dataflow Gen2 in Microsoft Fabric to prepare a sales fact table. The Sales query contains a ProductKey column, and you need to enrich each sales row with the ProductCategory and ProductBrand attributes stored in a separate Products query. Every sales row must be retained, even if a matching product record is temporarily missing. Which transformation should you apply?

Accepted Answer

Merge the Sales query with the Products query using a Left Outer join on ProductKey, then expand the ProductCategory and ProductBrand columns.

Answer

Append the Products query to the Sales query so the category and brand columns are added to the result.

Answer

Merge the Sales query with the Products query using an Inner join on ProductKey, then expand the category and brand columns.

Answer

Group the Sales query by ProductKey and add aggregate columns for ProductCategory and ProductBrand.