Forum Discussion

RichFlorida's avatar
RichFlorida
Icon for Helper V rankHelper V
4 years ago
Solved

View generated SQL statement for a visual

 

I'm trying to validate the data in a table visual.

Is there a way to view the SQL statement generated behind the scene that returnes the displayed results?

 

Please advise!

 

 

note: I using a direct connection to the database,  I only get Report and Model views, I do not get the Data View.

 

 

 

Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    In the Report view open Performance Analyzer. Start Recording. Refresh Visuals. Grab the query for the visual you are interested in and examine it in DAX Studio.  NOTE:  DAX Studio will ask you if you want to load both queries. Say "yes" there. One of the queries will be DAX, the other will be the native query.

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    In the Report view open Performance Analyzer. Start Recording. Refresh Visuals. Grab the query for the visual you are interested in and examine it in DAX Studio.  NOTE:  DAX Studio will ask you if you want to load both queries. Say "yes" there. One of the queries will be DAX, the other will be the native query.