Forum Discussion
powerbiexpert22
Impactful Individual
Impactful IndividualSnowflake schema
i need to convert snowlfake schema into star schema, the only way i can think is by denormalizing tables however i am not sure which tables i should consider for denormalization, also is there any ot...
DaniyalKhaleel1
Helper I
Helper IYes,denormalizing is one part of converting a snowflake model to a star schema, but you should not simply denormalize everything.If you are doing this in Microsoft Fabric for a Power BI semantic model, I would approach it as a dimensional-model redesign, not as a table-by-table conversion. Microsoft recommends star schema for analytical workloads: facts contain events/measures at a consistent grain, while dimensions contain the attributes used for filtering/grouping