Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
We are experiecing significant delays with certain visuals on data connected to a SSAS cube. The visuals being used are a simple table visual with three columns (two of those columns are DAX calculations). The report does also have two page level filters and four visual level filters which could be causing the slow down. Any suggestions on how to fix this issue?
Hi @Anonymous ,
You could use DAX Studio to evaluate and improve 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
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.