Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Star schema

Hi,    I have a normal star schema in my model but there are two related dimensions that i am unsure about (see below for picture).    I am only able to connect the ID from "no of products table"...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi

     

    To me it seems logical to join those tables.

     

    You can follow other types of models in Power BI and still be following the best practices. It all depends on the analysis you want to make.

     

    If you want, you can share your model and the relationships and we can try to help.

     

    Also read this article abour modeling:

    https://radacad.com/power-bi-basics-of-modeling-star-schema-and-how-to-build-it

     

    Kind regards,
    José
    Please mark this answer as the solution if it resolves your issue.
    Appreciate your kudos! 🙂