Last Modified Date: 15 May 2018
EnvironmentTableau Desktop 10.3 and older versions.
Option 1Upgrade to Tableau Desktop 10.4. For more information, see Upgrade Tableau Desktop.
Option 2Add a dummy parameter to the calculation. For example:
IF [Parameter 1] = 1
THEN <original calculation>
CauseIn Tableau Desktop 10.3 and earlier, when refreshing an extract Tableau Desktop queries the data source to compute the calculation. Some calculations are not supported or return different values on a live connection. See the related links for some specific occurrences.
When a parameter is added to the calculation, Tableau Desktop will not try to materialize the calculation into the extract because the values may change if the parameter value changes.
- After the extract is completed, if the formula is modified enough then the calculation will work. For example, if white space is added to the middle of the formula.
- The unexpected results will remain if the connection is switched to live. On a live connection, no modifications to the calculation will return the expected results.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials