Performance tuning

[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.

[sasshaikh]

Follow below two link for powerBi performance 

https://link.medium.com/6IbHXLfC3xb

https://link.medium.com/558JTPgC3xb

[dippatel1994]

Hi,

I was searching for a similar thing to improve model performance on powerBI. I found this article which helped me understand it better. It also talks about data acquisition, model advancement, and report creation-related strategies. 

PowerBI Data Modelling Performance Improvement Strategies Used by Professionals  

[v-luwang-msft · Accepted solution]

Hi @Anonymous ，

Just as lbendlin mentioned,you could use DAX Studio to evaluate query performance. And you could improve Power BI performance  through the following ways:

1.Turn off auto date/time

2.Remove unnecessary columns

3.Optimizing the data model

4.Reducing the number of values but not the information

5.Reducing precision

6.Choosing measures over calculated columns

7.Optimize your DAX

To learn more details ,you could read the following articles:

10 Best practice tips to improve your Tabular Model performance

HOW TO IMPROVE POWER BI PERFORMANCE - PART I
HOW TO IMPROVE POWER BI PERFORMANCE - PART II
HOW TO IMPROVE POWER BI PERFORMANCE - PART III

Wish it is helpful for you!

Best Regards

Lucien

[lbendlin]

Use DAX Studio to evaluate query performance. Then make a decision on what to change.