KNOWLEDGE BASE

Error "Invalid Field Formula"


Published: 09 Sep 2016
Last Modified Date: 30 Sep 2016

Issue

When interacting with a view in Tableau Desktop or Tableau Server, the following error occurs: 
Invalid field formula due to limitations in the data source.

Environment

  • Tableau Desktop
  • Tableau Server

Resolution

  • Check the Data pane for fields with red exclamation marks next to them. These represent fields which are used in the workbook, but are missing from the underlying data source. If you see these exclamation marks, modify the workbook so it does not rely on the missing data. 
  • Check for nested equations. Check your workbook for calculated fields which contain other calculated fields which reference secondary data sources. If these types of calculations are used in your workbook, modify the calculation so it does not use nested equations. 
  • Check data source and extract filters. If a data source filter or extract filter relied on a field that was removed from the database, the filter will need to be removed or altered. 
  • Ensure that the computers running Tableau Desktop or Tableau Server are using the correct drivers. See Drivers & Activation for a list of supported database drivers.
  • If the above suggestions do not resolve the issue, create a new data connection. See Replacing a Data Source for more information. 
  • The issue only occurs in Tableau 8.X and below and has been fixed in 9.0 and up.

Cause

A field used in the workbook is missing from the underlying data. 
Did this article resolve the issue?