Question

You are building a dimensional model in a Fabric warehouse. The source contains three normalized tables: Product, ProductSubcategory, and ProductCategory, linked by foreign keys in a snowflake pattern. Your Power BI report authors complain that navigating three related tables makes measures and filters confusing. You want to optimize the model for query performance and report usability while following star schema best practices. What should you do?

Accepted Answer

Denormalize the three tables into a single DimProduct dimension by joining them, so category and subcategory attributes are columns in one flat table.

Answer

Keep the three tables separate and create relationships between them so the snowflake structure is preserved in the semantic model.

Answer

Create a view that unions the three tables into a single result set containing all rows from each table.

Answer

Move ProductCategory and ProductSubcategory into the fact table as additional columns while leaving Product as a separate dimension.