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

[Anonymous]

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 shown. But the visual definitely pulls data from a direct query data source so there has to be some query statement. But it is missing. 

I´ll be installing DaxStudio but it would be much simpler if the performance analyzer showed me both parts of the statement. Does anybody know how to get the DirectQuery statement?

Alexander 

[Anonymous]

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

[amitchandak · Accepted solution]

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