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 ,
I suggest you use Performance Analyzer in Power BI Desktop to rule out whether it is the cause of power bi service or gateway. Please refer to https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-performance-analyzer
I also suggest you try to update your gateway to the latest version and please ensure that the gateway is close enough to the data source, and whether the performance of the server where the gateway is installed is excessively invaded by other software.
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