10 Replies Latest reply on Apr 23, 2012 6:47 PM by Robert Morton

    ...errors in the "Initial SQL" dialog box caused a refresh to abort or at least throw and error.

      Given the size of many of the fact tables in our cluster, we often use the “Initial SQL” dialog box to create a series of temp tables with subsets of the data before the final Select query.  One issue we have been encountering lately is that if there is an error from one of the steps in the “Initial SQL” section, Tableau does not abort the refresh of data.  Instead of aborting, Tableau continues to the next step in the SQL.  This can lead to partial data appearing in the Tableau report.  In most cases, we would rather have the refresh throw an error since partial data can sometimes be misleading.  Having an error reported would also help us a lot when de-bugging reports.