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