-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

Expert Data Modeling with Power BI
By :

In real-world scenarios, the data models can get very busy, especially when we are creating a data model to support enterprise BI; there are many instances that we have an inactive relationship in our data model. In the majority of cases, there are two reasons that a relationship is inactive, as follows:
In both preceding cases, the engine does not allow to activate an inactive relationship to avoid ambiguity across the model.
A filter path between two tables is when the two tables are related via multiple tables. Therefore, the filter propagates from one table to the other via multiple hops (relationships). The following diagram shows a data model with an inactive relationship:
Figure 9.14 – Inactive relationship due...