Loading

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

Publiceringsdatum: Apr 24, 2026
Beskrivning

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

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.
 
Lösning
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.
Ytterligare resurser
Parameters in the custom SQL query can provide dynamic values during the connection. See Use parameters in a custom SQL query.
Parameters in the Viz can give users a way to interact with views. See Use Parameters to Make Views More Interactive.
Knowledge-artikelnummer

001471714

 
Laddar
Salesforce Help | Article