PowerBI Performance Tunning

[Anonymous]

I would need help regarding the best practises and recommendations from PowerBI experts related to Performance tunning at PowerBI and SSAS Tabular data model. This powerBI dashboard was built on top of SSAS tabular model

The testing team executed testing scripts with load runner tool and found the performance of the powerbi report was not up to mark . They tested set of users ( ~40 Users) for different scenerios GUI/ PowerBI URL launching/Drill through option of different pages/Clicking on reset button/selecting the values from slicers etc.

What are best recommendations to improve the performance of this powerBI dashboards and SSAS model.

1) Hiding the unnecessary objects in the SSAS  improving the performance?

2) Naming of the measures ( There are certain fields which are having special charcherts)

3)  Apply aggegrations

4) Partitions would help?

5) Any recommendations at BI serice level ( tenet settings, capacity increase etc)

Kindly suggest the best practises and recommendations.

[v-cazheng-msft · Accepted solution]

Hi @Anonymous 

To optimize the performance of Power BI report, we firstly need figure out what area is the reason of slowdown. Data model, visualizations and environment are all the possible reasons causing poor performance. For SSAS, you can consider creating hierarchies with attribute relationships, partition measures and  create aggregations for large Measure Groups to improve the performance of the report.

For more details about areas causing slowdown and examine tool, you can refer these official documents Use Performance Analyzer to examine report element performance and  Optimization guide for Power BI.

For performance tuning at SSAS data source, you can refer Performance SSAS Best Practices.

Best Regards

Caiyun Zheng

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.