Loading

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

Publiseringsdato: Apr 24, 2026
Beskrivelse

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.
Flere ressurser
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-artikkelnummer

001471714

 
Laster
Salesforce Help | Article