Forum Discussion
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
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.
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.
1 Reply
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.
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.