Forum Discussion
Helper IPower BI performance - DAX queries vs MDX queries
Hi arcellie ,
It could be some dax query can't make use of the Analysis Services Storage Engine cache. What's the version of your SSAS. This problem has finally been fixed as part of the general SuperDAX performance improvements in Analysis Services 2019 CU5. For more details, please refer to https://blog.crossjoin.co.uk/2016/09/26/ssas-multidimensional-caching-related-performance-problems-with-power-bi-tables/
For the performance in Power BI service. Most likely due to the network. You can use Fiddler to see the back and forth with the Power BI service from the client machine. This traffic list might show errors and other related information.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Community SupportHi arcellie ,
It could be some dax query can't make use of the Analysis Services Storage Engine cache. What's the version of your SSAS. This problem has finally been fixed as part of the general SuperDAX performance improvements in Analysis Services 2019 CU5. For more details, please refer to https://blog.crossjoin.co.uk/2016/09/26/ssas-multidimensional-caching-related-performance-problems-with-power-bi-tables/
For the performance in Power BI service. Most likely due to the network. You can use Fiddler to see the back and forth with the Power BI service from the client machine. This traffic list might show errors and other related information.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai