Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
63 | |
63 | |
53 | |
39 | |
25 |
User | Count |
---|---|
85 | |
57 | |
45 | |
43 | |
38 |