7 Replies Latest reply on Sep 16, 2016 11:07 AM by Dmitry Chirkov

    SQL table update not reflected in extract refresh

    Christopher Mederos

      Hi all -

       

      I've encountered an issue when an underlying table in SQL is changed, but the update isn't reflected after refreshing the extract in tableau.

       

      the exact order:

      1. Connect Tableau to a table in MS SQL
      2. Extract data
      3. Run an update statement in SQL on the sane table ( UPDATE TABLE SET FIELD = 'YES' WHERE YEAR = 2016)
      4. Refresh extract
      5. Tableau still displays data with old values, not updated to "YES"

       

      I haven't confirmed this entirely - but I think this is sometimes solved by using a custom SQL "SELECT * FROM TABLE" instead of directly connecting to the table.  If anyone has any insight, I would greatly appreciate the help.

       

      Thank you,

      Chris