Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Star Schema - Should I reference or duplicate?

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,

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

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


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Greg_Deckler
Super User
Super User

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


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.