2 Replies Latest reply on Nov 20, 2017 5:21 AM by Donna Coles

    Strange issue when connecting to a SQL stored procedure

    Shaun Brookes

      I'm getting a very strange issue when connecting to a SQL stored procedure in Tableau. Every time I refresh the dashboard, the stored procedure executes 3 times instead of 1. This results in extremely slow run times. The reason I know for certain that it is executing 3 times is i tested it by creating a simple stored proc that selects 1 record from a table and then inserts this record, along with a timestamp into another table. When I go view this table, it contains 3 records, all with slightly different timestamps.

       

      Anyone have any idea why this is happening or how I could stop it from happening?

       

      Thanks