cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
Poova
Frequent Visitor

How to create data model with limited dimensions but multiple fact tables

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? 

 

 

1 ACCEPTED SOLUTION
MisterFry
Resolver III
Resolver III

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'.  

View solution in original post

2 REPLIES 2
Poova
Frequent Visitor

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 🙂 

MisterFry
Resolver III
Resolver III

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'.  

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

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!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors