topic Star Schema - Should I reference or duplicate? in Developer

Star Schema - Should I reference or duplicate?

Anonymous — Tue, 12 May 2020 12:43:01 GMT

Hi All,

I am starting a Star schema data model from a single table and I have this question:

How should I create the dimensions tables? referencing the main table? duplicating it?

I have read some articles but I couldnt find the best approach.

Thanks,

Re: Star Schema - Should I reference or duplicate?

Greg_Deckler — Tue, 12 May 2020 13:14:28 GMT

Probably best practice would be to Reference your main query in Power Query editor and remove all unneeded columns. This would be how you would create your dimension tables.

You could also do it in DAX using SELECTCOLUMNS and DISTINCT

Re: Star Schema - Should I reference or duplicate?

Anonymous — Tue, 12 May 2020 13:20:49 GMT

Thanks, I also found this useful article:

https://radacad.com/performance-tip-for-power-bi-enable-load-sucks-mem ory-up