View generated SQL statement for a visual

[RichFlorida]

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.

[RichFlorida]

Thank you @lbendlin 

[lbendlin · Accepted solution]

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.