4 Replies Latest reply on Jun 23, 2016 9:07 AM by Dmitry Chirkov

    How do I know the actual queries executed behind the Tableau? (Performance Managment)

    sameer.palladwar

      Hey Tableau Enthusiast,

       

      I am having a dashboard which loads data from Live server and renders visualization. It takes ~ 1.5 - 2 minutes to execute the queries/calculated fields.

       

      The objective is to reduce the execution time to be <1 minute. In order to optimize the query/performance, I would like to analyze the actual query, and run the same in DB Engine.

       

      One way I know is to look into log files, however, its painstaking and does have actual fields reflecting. I would appreciate your suggestions on -

      1. How do I figure out actual queries?

      2. What other measures you think for optimizing performance?

      3. Calculated fields refer to multiple Ifs statements, any work around for this ?

       

       

      Thanks !