KNOWLEDGE BASE

Extract Refresh Unsuccessful When Using User Filters


Published: 07 Feb 2014
Last Modified Date: 16 Jun 2017

Issue

When a published extract includes user filters, when you try to refresh the extract on Tableau Server, one or more of the following symptoms might occur:
  • The view might be blank.
  • The view might display all data, without any filtering.
  • The following message might appear when the refresh completes:
Data source refresh completed. 0 rows uploaded

Environment

  • Tableau Server
  • Extracts
  • User filters

Resolution

  1. In Tableau Desktop, open the workbook connected to the extract.
  2. Right-click the extract in the Data pane, and then select Extract Data.
  3. In the Filters (optional) section of the Extract dialog box, remove all user filters and any other filters listed, and then click Extract.
    This step will only remove user filters from the extract and will not affect the user filters in the workbook.
  4. Publish the workbook to Tableau Server. For more information, see Publishing to Tableau Server in Tableau Help.

Cause

When data source filters are added to extracts in Tableau Desktop, the filter is automatically added to the extract. This improves performance in Tableau Desktop, but the extract-level filters must be removed before you publish to Tableau Server to avoid filters that Tableau Server cannot evaluate.
Did this article resolve the issue?