CODEWITHSUNDEEP
powerbipowerquerydata-modelingdimensional-modelingstar-schema
Frank Peltz
Frank Peltz

Reputation: 1

How to deal with Foreign Keys into Dimension Tables

I am trying to separate the following fields into a new dimension table called Territory.

Power BI Model

As you can see, there is no TerritoryKey in the Fact Table I have.

As the columns should not repeat in a Star Schema, how can I separate those columns into a new dimension table and then delete the original ones?

Is there any option I can apply with Power Query or SQL?

I tried to call those fields into Order Details (Fact Table), create a new table related to this columns and then delete the columns from the fact table and the Products Table with Power Query.

But if I delete any of this columns, all their fields become null.

Upvotes: 0

Views: 167

Answers (1)

David Browne - Microsoft
David Browne - Microsoft

Reputation: 89316

Merging the Product's supplier's attributes on every Product dimension row is the correct star schema design.

Naturally the Supplier would be a snowflake dimension related to the Product. That's a valid approach too.

But it's not usual to make the snowflake dimension a stand-alone dimension directly related to the fact.

Upvotes: 1

Related Questions