Creating a Shared Dimension in Power BI Using Power Query Basics and Foundations of Modeling
For a data warehouse professional, a shared dimension concept is always clear, and a star schema design always includes such type of entity. However, in the Power BI user’s world, there are many users who are not coming from a data warehousing background. It is necessary to understand some of the concepts in order to design a good performing Power BI model. I will be writing about some of the concepts in an easy-to-understand way in some articles, here is the first one; What is a shared dimension, and why do you need that in your Power BI model? In this blog post, I will explain how it can prevent many issues, as well as the need for both directional relationship.
Learn more by reading my article about it here:
https://radacad.com/creating-a-shared...