Question

You are building a star schema in Power BI Desktop. The Sales fact table contains one row per order line and includes a ProductKey column. The Product dimension table contains one row per product with a unique ProductKey. When you create a relationship between the two tables on ProductKey, which cardinality and cross-filter direction should Power BI apply by default and that you should keep for optimal query performance?

Accepted Answer

Many-to-one (*:1) from Sales to Product with a single (one-way) cross-filter direction

Answer

One-to-one (1:1) with a single cross-filter direction

Answer

Many-to-many (*:*) with both cross-filter direction

Answer

Many-to-one (*:1) from Sales to Product with both (bidirectional) cross-filter direction