KNOWLEDGE BASE

Filters Using Parameter In Custom Sql Does Not Work After Switching Data Source From Live To Extract


Published: 07 Dec 2020
Last Modified Date: 07 Dec 2020

Issue

Filters using parameters in customer SQL does not work after changing the data source from live connection to extract.
The viz is not updated.

Environment

  • Tableau Server
  • Tableau Online

Resolution

Workaround 1:
Refresh the extract.

Workaround 2:
Use parameters in the Viz.
  1. Remove the inserted parameters and delete the WHERE clause.
  2. (Optional) Filter data from Data Sources instead of using the WHERE clause. See Create a data source filter.
  3. Create extracts.
  4. Create parameters. See Create a parameter.
  5. Re-publish the extract and workbook.

Cause

This behavior is by design. The data source needs to be refreshed when you change the parameters and when you switch the data source from live to extract.
 
Did this article resolve the issue?