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

Published: 07 Dec 2020
Last Modified Date: 08 Jul 2022


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


  • Tableau Server
  • Tableau Cloud


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.


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?