Last Modified Date: 14 Oct 2019
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.
Discuss this article...
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials