Forum Discussion

JackWong's avatar
JackWong
Frequent Visitor
8 years ago

Will this Data model affect Power BI Performance?

Hi guys,

Just would like to understand if this kind of data model will affect the power bi performance? Will Star schema or snowflake scehma able to increase the performance?

3 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    8 years ago

    HI @

     

    It looks mostly ok.  The image is pretty grainy.  Do you have any bi-directional relationships?

    • JackWong's avatar
      JackWong
      Frequent Visitor
      8 years ago

      there are some bi-directional relationships but mostly single direction. We are having some performance issues and wondering if this model design will affect the performance. Will it be more optimised using star schema or snowflake schema?

      • Phil_Seamark's avatar
        Phil_Seamark
        Microsoft Employee
        8 years ago

        Star will be faster.

         

        Make sure you also remove ALL unused columns from every table - especially your larger tables.