Showing results for 
Search instead for 
Did you mean: 
colivares62 Frequent Visitor
Frequent Visitor

Facts and Dimensions still useful with Power BI ?

Hi, I'm starting a Data Mart from scratch for a HR database.  In a traditional DW model, I would have organized data in Facts and Dimensions.  However, I don't know if Power BI would benefit from that or it would be better to directly organize data in flattened tables, I mean, denormalizing all data and putting dimensions valued directly in the fact tables.  I would keep only "special" dimensions separated like Time and Geographical data.


Thanks !




Super User
Super User

Re: Facts and Dimensions still useful with Power BI ?

There are several blog posts out there indicating that Power BI is faster with dimensions versus everything being flat. Remember, under the hood, Power BI is a tabular cube so normal design rules for tabular cubes still apply. 

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!