Forum Discussion
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 ...
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?
Yes, it provides a breakdown of basically each step of the query and how long it is taking.