Will this Data model affect Power BI Performance?

[JackWong]

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?

[Phil_Seamark]

HI @

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

[JackWong]

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]

Star will be faster.

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