Strong and weak relationships in Power BI
Weak relationships have been introduced in Power BI with composite models in 2018. Even though they look like regular relationships, they hide some complexities. These relationships are part of the Tabular model, even though as of September 2019 it is not possible to use composite models in Analysis Services. Nevertheless, Analysis Services 2019 enables using weak relationships without using composite models, so this article is relevant to any future Tabular model that could use weak relationships. For this reason, when the article references the “Tabular model” the concepts can be applied to both Power BI and Analysis Services.