Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
I need to create a dashboard using multiple excel files that are coming thru automated workflows. Each file is a fact file but the fields are all different except 3 columns. Each of the 3 columns have a dimension related table in Data warehouse.
So when I load all fact tables and dimension tables, I am looking at 5-6 fact tables with common columns connected to each of the dimension table.
How do I create a star schema (or) any other alternative to have a clean data model?
Solved! Go to Solution.
Hi Poova,
You've kinda answered your own question here.
You would create one-way relationships between each of the dimensions, and each of the facts, where relevant. Because you're using one-way relationships, you won't run into circular references.
In the case of many to many relationships, you can still specify a single cross filter direction though the default is 'both'.
Thank you ! Initially i was skeptical about the data model as I was always thinking the model should be star / snowflake type but the model I work is kind of exactly opposite to star model. However, I tried to create dashboard based on your tips above. So far so good 🙂
Hi Poova,
You've kinda answered your own question here.
You would create one-way relationships between each of the dimensions, and each of the facts, where relevant. Because you're using one-way relationships, you won't run into circular references.
In the case of many to many relationships, you can still specify a single cross filter direction though the default is 'both'.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!