Best practices for PBI

[Paulyeo11]

Hi All

it is goos to shift all Dimension to one Table and Expression to Another table . So that user will find it more user friendly. And Group the field by table for example GL AR AP etc.

I am concern what are the consequences.

Paul

[amitchandak · Accepted solution]

@Paulyeo11 , it better to a related dimension to one table. Do not make one fact one dimension unless that is the only possibility. refer v

https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/

https://www.sqlbi.com/blog/marco/2017/10/02/why-data-modeling-is-important-in-powerbi/

Also, refer

https://maqsoftware.com/expertise/powerbi/power-bi-best-practices
https://docs.microsoft.com/en-us/power-bi/guidance/power-bi-optimization
https://www.c-sharpcorner.com/article/power-bi-best-practices-part-1/
https://www.knowledgehut.com/blog/business-intelligence-and-visualization/power-bi-best-practices