Forum Discussion
How to run DAX queries in parallel
Hi all,
I have created a dashboard in Power BI which has multiple visuals. In Power BI, I have set up max parallel evaluations to 4, which means 4 queries can run in parallel (in a batch).
I want to replicate the same with DAX studio or any other tool to performance test my reports. I see that, when I mention all the DAX queris in DAX studio (one evaluate for each query), it runs them in waterfall fashion.
How can I run these DAX queries in batch mode, like 4 at a time in parallel?
Hi abhishekjangid ,
If you want to performance test your reports, please consider about using Monitor report performance in Power BI Desktop.
Monitor report performance in Power BI Desktop using the Performance Analyzer. Monitoring will help you learn where the bottlenecks are, and how you can improve report performance.
Monitoring performance is relevant in the following situations:
- Your Import data model refresh is slow.
- Your DirectQuery or Live Connection reports are slow.
- Your model calculations are slow.
Slow queries or report visuals should be a focal point of continued optimization.
For more details, please refer to:
Monitor report performance in Power BI - Power BI | Microsoft Learn
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.
1 Reply
Hi abhishekjangid ,
If you want to performance test your reports, please consider about using Monitor report performance in Power BI Desktop.
Monitor report performance in Power BI Desktop using the Performance Analyzer. Monitoring will help you learn where the bottlenecks are, and how you can improve report performance.
Monitoring performance is relevant in the following situations:
- Your Import data model refresh is slow.
- Your DirectQuery or Live Connection reports are slow.
- Your model calculations are slow.
Slow queries or report visuals should be a focal point of continued optimization.
For more details, please refer to:
Monitor report performance in Power BI - Power BI | Microsoft Learn
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.