Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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.
Solved! Go to 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
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
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
Use DAX Studio to evaluate query performance. Then make a decision on what to change.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
99 | |
69 | |
46 | |
39 | |
33 |
User | Count |
---|---|
163 | |
110 | |
61 | |
51 | |
40 |