Performance Analyser Breakdown

[alexwhittaker]

Hi All,

I'm in the process of using Performance Analyser to examine report timings. For the output JSON I can extract Visual Display Time, DAX Query Time, Other Time and Direct Query Time. Wondering how I should sum these timings to give a 'Total' Time as I'm aware the timings happen in parallel with each other and not sequentially.

Thanks 🙂

Alex

[Aqila_Balqis]

I am not sure what you mean by "how I should sum these timings to give a 'Total' Time" but I came across this post because I am wondering why my Total Ms in Performance Analyzer is not the same when I sum the breakdown query ms. 

Then I found a great answer here: Measuring DirectQuery Performance In Power BI - Chris Webb's BI Blog (crossjoin.co.uk) which help me understand more on the performance analyzer.

Hope this help anyone that came across this post!

[dax]

Hi @alexwhittaker , 

I am not clear about your requirement, did you mean that you want to get the one visual's preformance seperately? If so, you could click "Start Recording", then click corresponding visual instead of click refresh visual, which should show only corresponding visual's performance.

Best Regards,
Zoe Zhi

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