Forum Discussion
Impactful IndividualSnowflake to Star Schema conversion
What approach I should follow to convert snowflake schema to star schema, example , on what basis I would decide which tables I need to combine to make single table (denormalized table)
Hi powerbiexpert22 ,
Based on the description, try to examine the relationships between tables in the snowflake schema and identify the entities.
Then, combine the related tables into a single dimension table.
You can also view the following links to learn more information.
Understand star schema and the importance for Power BI - Power BI | Microsoft Learn
Understand star schema and the importance for Power BI - Power BI | Microsoft Learn
Model relationships in Power BI Desktop - Power BI | Microsoft Learn
Solved: From Snowflake to Star Schema - Microsoft Fabric Community
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- Greg_Deckler
Community Champion
powerbiexpert22 So, if you have a snowflake schema you can generally just follow the path from the fact table. You should have a dimension related to the fact table. Any additional tables that are related to that dimension table you can collapse into the dimension table. This is general case, you specifics might be different.
Hi powerbiexpert22 ,
Based on the description, try to examine the relationships between tables in the snowflake schema and identify the entities.
Then, combine the related tables into a single dimension table.
You can also view the following links to learn more information.
Understand star schema and the importance for Power BI - Power BI | Microsoft Learn
Understand star schema and the importance for Power BI - Power BI | Microsoft Learn
Model relationships in Power BI Desktop - Power BI | Microsoft Learn
Solved: From Snowflake to Star Schema - Microsoft Fabric Community
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
