Reply
Bakhtawar
Post Patron
Post Patron

northwind database star schema

HI ALL

 

I am trying to create northwind database star schema.. this is what i create please let me know is this correct ot not 

and one more thing is that i want to create primary key icon .. like in suppliers table suppliers id is primary key so i create icon like this 

1.JPG

 
 
 

nw.JPG

1 ACCEPTED SOLUTION
v-xuding-msft
Community Support
Community Support

Hi @Bakhtawar ,

It is a snowflake schema rather than a star schema. You need to create the relationships between per Dimension tables and Fact table directly to create a star schema.  You could reference the document to learn more: Understand star schema and the importance for Power BI.

3.PNG

And for primary key icon, it is not supported in Power BI for now. If you really need it, you could submit the request in Ideas and vote it up to get fixed quickly.

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-xuding-msft
Community Support
Community Support

Hi @Bakhtawar ,

It is a snowflake schema rather than a star schema. You need to create the relationships between per Dimension tables and Fact table directly to create a star schema.  You could reference the document to learn more: Understand star schema and the importance for Power BI.

3.PNG

And for primary key icon, it is not supported in Power BI for now. If you really need it, you could submit the request in Ideas and vote it up to get fixed quickly.

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)