> The reason why I rebuild my data model is that actually I have 5-6 fact tables which contain around 47mil rows up to 120mil rows. Also, the tabular model will store the data in memory so please check if you have enough memory. Because the engine will store unique column values there is a high compression on your data model. I would like to answer your questions below:īeforing considering changing to a snowflake model I would spent some time finding out why your current model should be rebuild? Is there s performance issue? The reason I ask is that 47mil rows shouldn't be that big of a problem in Power BI. In addition, Is there any disadvantages of snowflake schame in comparison with star schema? Please help. My question is that when I design my data model in snowflake schema, Is Power BI able to drill up and drill down value in the hierarchy of dimension? (For example, if I have hierarchy with 3 levels, I will break them down into 3 tables - the highest level will be mapped with fact table, the second level will be mapped with the first level and the third level will be mapped with the second level). Therefore, I would like to redesign my model to snowflake schema which (I think) will reduce the amount of rows in the fact table because the fact table only need to map with the highest row of the hierarchy in the dimension. With this model, the fact table contains too many rows (47mil rows) because it has to map to the lowest row of the hierarchy in each dimension. Currently, I have star schema in my data model which contains 1 fact table with 5 dimensions (& hierarchy in each dimention).
0 kommentar(er)
