Forum Discussion
Query Tracing and performance issues
Look at the applied steps on the right hand side of he query editor. Right click on the first step and select Native Query. This is the query folded code being sent to the server. Work your way down the list, right clicking until this menu is greyed out. The first step where it is greyed out is the step that is causing query folding to stop. When query folding stops, power query takes over, and this is less efficient. The general rule is to use the menus (on manual code) for as long as possible to keep query folding going.
We're running Analysis Services multidimensional as the data source so unfortunately the 'view native query' menu isn't supported. We ran a Profiler trace at the server level and it captured what I was looking for and confirmed that it folded in multiple steps into 1 query.
