Forum Discussion

alexwhittaker's avatar
alexwhittaker
Frequent Visitor
6 years ago

Performance Analyser Breakdown

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

Need Help

2 Replies

  • dax's avatar
    dax
    Community Support
    6 years ago

    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.

  • Aqila_Balqis's avatar
    Aqila_Balqis
    Frequent Visitor
    3 years ago

    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!