Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Icon for Impactful Individual rankImpactful Individual
4 days ago

Snowflake 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...
Need Help
power bi
LumericVisuals's avatar
LumericVisuals
Icon for Helper II rankHelper II
4 days ago

denormalize from the outside in (the dimension-of-a-dimension layers, not the ones touching the fact table), do it via Power Query merges, and notes VertiPaq compression makes storage bloat a non-issue — the real win is DAX simplicity.