cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Akshay_Kinge
Frequent Visitor

Why is the total duration for DAX query vastly different from what is shown under DAX Studio ?

@v-shex-msft


So I am new to optimizing Power BI , and what I learnt from online is to turn on the performance analyzer and look for DAX queries taking more than 120 ms to run.


Here, I have 67 visuals in one page , I ran the performance analyzer
sort it in DESC order of DAX query duration , and found 1st visual whose DAX query took 847 ms to run.

Akshay_Kinge_0-1616398855639.png


I copied it to DAX studio and there it ran for 64 ms.

Akshay_Kinge_1-1616398893777.png

What does this mean ? Is the DAX query already fast as it is and due to may small RAM of 4GB that 64ms takes 847ms ? Or do I need to do further optimization?

I also know that SE queries above 20 is an indicator that DAX query needs to be optimized, but this 12.

Any help would be greatful as I am completely new to Power BI Optimization.

2 REPLIES 2
selimovd
Community Champion
Community Champion

Hello @Akshay_Kinge ,

 

probably the query is cashed.

When you do the Query in DAX studio, always chose the "Clear Cache then Run" option:

10.png

 

This should give you a more realistic time of the query.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

 

Yes I have done this and still got this issue.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors