Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
MartinBurman
New Member

Help understand server timings timeline in dax studio

After facing some performance bottlenecks I started looking into the Server Timings page in Dax Studio to better understand what's going on. 
As you can see this expression took more than 45 seconds. We then look at the individual rows and try to se which ones take the most time and try to optimize that part. 
Question 1)
   There is a duration column, but summarizing those values only gives us the SE queries duration?
Question 2)
   If we look closer at rows 86 and forwards we see there is a huge leap from the timings indicator even though the last operation only took 1 ms. What's going on here? Is it the Formula Engine cranking for dear life without any traces? How would i go about to optimize this..?
Question 3)
   Do you recognize this charcteristic of the timeline that we have two huge operations more or less and can explain in general what could be poorly configured/usual suspects...?


MartinBurman_2-1714652982549.png

 

 



MartinBurman_0-1714652557527.png

 

 

 

1 ACCEPTED SOLUTION

We are trying! Currently we have identified odd performance behaviour with 
SWITCH
 Selectedvalue(Parameter1),
 "Option1",Measure1
 "Option2",Measure2
 "Option3",  DefaultMeasureIfNothingSelected (but as an option...)
 DefaultMeasureIfNothingSelected
 
Where the default of the switch is 2 seconds (6->4) faster than if we have selected the option that will return the same measure.

View solution in original post

2 REPLIES 2
Alex87
Solution Sage
Solution Sage

you have 50 queries that are 99.9% using the formula engine. You need to change the way you wrote your formula. Try different variations. Do not forget to use variables and optimize the number of queries as max as possible




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!




We are trying! Currently we have identified odd performance behaviour with 
SWITCH
 Selectedvalue(Parameter1),
 "Option1",Measure1
 "Option2",Measure2
 "Option3",  DefaultMeasureIfNothingSelected (but as an option...)
 DefaultMeasureIfNothingSelected
 
Where the default of the switch is 2 seconds (6->4) faster than if we have selected the option that will return the same measure.

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.