Forum Discussion

Bakhtawar's avatar
Bakhtawar
Post Patron
6 years ago
Solved

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 .. lik...
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    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.

v-xuding-msft's avatar
v-xuding-msft
Community Support
6 years ago

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.