Forum Discussion

ddumas's avatar
ddumas
Frequent Visitor
8 years ago
Solved

creating a multi-fact star schema

I am new to Power BI, and am trying to understand managing relationships .  I am well versed in using star schemas.   Let say I have 2 fact tables:   Fct_Sales Fct_Service   Both of these shar...
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi ddumas,

     

    Maybe your relationships could be like this. No loops here. You can have a try.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
8 years ago

Hey,

 

basically it's no problem to have more than one fact table, some shared dimension tables and some dimension tables that are not shared.

 

Indeed it can become a little more difficult if there are more complex relationship you have to handle, like cascading many-to-many.

 

I strongly recommend to invest some money and buy the "Analyzing Data with Power BI and Power Pivot for Excel" by Albertro Ferrari and Marco Russo. This book is just about the data modeling aspects we have to tackle.

 

Hopefully this gets you started

 

Regards

Tom