KNOWLEDGE BASE

Warning "Field... which is included for filtering does not exist" When Opening Workbook


Published: 18 May 2021
Last Modified Date: 18 May 2021

Issue

When opening a workbook that was downloaded from Tableau Server in Tableau Desktop, the following error may occur:

Field 'Calculation_<number>' which is included for filtering does not exist.

Environment

  • Tableau Desktop 2020.1

Resolution

  1. Open the affected workbook in Tableau Desktop.
  2. Navigate to a worksheet that uses the data source.
  3. Create a local copy of the data source by selecting Data > <data source> > Create Local Copy.
  4. Save the local copy of the data source.
  5. Replace the published data source with the new local data source by selecting Data > Replace data source.
  6. Right-click the published data source and then select 'Close' to close the published data source.
  7. If any field has a red exclamation point in the data pane, right-click on the affected field, and select Replace References.
  8. Select Data > <data source> > Publish to Server to publish the updated data source to Tableau Server. Make sure to leave 'Update workbook to use the published data source' selected. 

Cause

The workbook uses a published data source and the calculation is defined in the workbook, but not the data source. 
Did this article resolve the issue?