Solved: Re: View generated SQL statement for a visual

RichFlorida · ‎07-15-2022

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.

lbendlin · ‎07-17-2022

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.

View solution in original post

RichFlorida · ‎07-18-2022

Thank you @lbendlin

lbendlin · ‎07-17-2022

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.