7 Best Practices to Optimize Power BI Model
During the development of Power BI dashboards we usually tend to create reports & deliver the output to client with good accuracy but with some haste. In this processes we often lose an eye on optimizing the performance and overall user experience.
Though in the initial development phase this might not come to surface but as the user requirements and complexity of the model grows: model optimization becomes pivotal.
Here are some tips to help solve the problem
1. Don’t use too many visuals:
The intent of a dashboard is to represent complex situation with minimum visuals. With too many visuals we make it difficult for user to apprehend & also hamper the performance of report.
According to ‘Power BI Optimization Guide’ reports should have not more than 8 visuals and one table per page.
