0

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.

Ian Boyd
  • 246,734
  • 253
  • 869
  • 1,219
Frank Peltz
  • 1
  • 1

1 Answers1

1

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.

David Browne - Microsoft
  • 80,331
  • 6
  • 39
  • 67