Forum Discussion

ajbogle's avatar
ajbogle
Helper I
4 years ago

Optimizing DAX

Hi guys,   One of my reports is running rather slow compared to other reports. I've been using the performance analyzer to try and determine what is causing the DAX to run rather slow. For the life...
Need Help
Duia's avatar
Duia
Resolver II
4 years ago

Hi ajbogle ,
You can try the following methods:
1. You can use the external tool DaxStudio to find the maximum run and analyze it.
https://daxstudio.org/

2. Are you using the Import connection mode, you can change it to the Direct query connection mode to speed up the refresh rate.
https://community.powerbi.com/t5/Desktop/DAX-and-Power-BI-Optimization/m-p/268589

3. Optimize the model in power bi to reduce unnecessary columns and data.
https://docs.microsoft.com/en-us/power-bi/guidance/power-bi-optimization

Solved: Transformations in Power Query - Very Slow Perform... - Microsoft Power BI Community

4. Dax optimization:
https://maqsoftware.com/insights/dax-best-practices

5. Modeling optimization:
https://community.powerbi.com/t5/Desktop/DAX-optimization/td-p/946984


Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.