cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
Alexander76877
Helper II
Helper II

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 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 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

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

View solution in original post

2 REPLIES 2
Alexander76877
Helper II
Helper II

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
Super User
Super User

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

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors