Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Performance Analyzer not showing results on DirectQuery - only on DAX Query

When I click on "copy query", the Performance Analyzer used to show the query statements both for DAX query and for Direct Query. I didn´t use it for a long time but now only the DAX query part is sh...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Anonymous , When I tried last time, in DAX query given both. Make sure query is not coming from cache

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Wow, you just solved a completely different problem of mine.

First of all, I cleared the caches under option/Global/Data Load. But that didn´t help, the directquery statement still didn´t occur. 

 

Then I created a new PBI report from scratch, connecting to a datamart via DQ. Now performance analyzer showed the DQ statement. So far so good.

 

Then I created another new PBI report from scratch but now connecting to the data source I have the trouble with, again via DQ. Performance analyzer still does not show DQ statement. Completely weird. 

 

The difference is that the second data source is Azure Data Explorer, connected via DQ. Definetely no import but still no DQ statement. This seems to be the reason why I have performance issues with ADE in the first place - query caching from ADE.

 

Thanks

Alexander