Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

Performance tuning

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.

 

 

1 ACCEPTED SOLUTION
v-luwang-msft
Community Support
Community Support

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

View solution in original post

4 REPLIES 4
sasshaikh
Frequent Visitor

Follow below two link for powerBi performance 

 

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

 

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

dippatel1994
New Member

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
Community Support
Community Support

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
Super User
Super User

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.