Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Improving formula engine performance

I have a query that's taking 55 seconds for the FE and 1 for the SE

 

DAX Studio obviously gives me the SQL and SE timings, but I can't see how to either

 

a) see what's taking 55 seconds in the FE

b) optimise FE performance

 

The query only includes 1 calculated column (basically: if x isblank, "no", "yes") and 1 measure (sum sales). The other fields are straight from the dwh. 

 

Is there a way of improving FE performance? 

Need Help

11 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    Have you messed around with the Power Query diagnostic options (Tools tab) or DAX Performance Analyzer (View tab)?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Greg_Deckler - thanks again for your help

       

      I've used the DAX PA to generate performance data for export to DAX Studio, and have been running queries there - following the approach of commenting out fields to see what's causing issues.

       

      Haven't used PQ diagnostic tracing - will need to learn more about it. Does it help query optimisation?

       

       

      • mahoneypat's avatar
        mahoneypat
        Microsoft Employee
        6 years ago

        Query diagnostics will help you troubleshoot your power query refresh, but not your DAX expressions.  Can you post your DAX expression so we can propose optimization changes?

        Regards,

        Pat