Filters not refreshing after changing dataset parameter via URL in QuickSight

Q&A
, , , , , , , , ,
2

@LuisBorrego Thanks for reaching out. I entered your issue into our Community chat agent and this is what I got. I have asked @Brett to validate this when back online on Monday – but hopefully in the meantime this will help you get unblocked. :slight_smile:

This is a known limitation in Amazon QuickSight when using Direct Query datasets. When a dashboard uses Direct Query, the filter and parameter controls cache their value lists, and this cache is not cleared when you adjust dataset parameters. 1

While the visuals re-query the source and update correctly when parameters change, the filter controls remain connected to the default parameter values. 1

The filter value cache refreshes automatically every 24 hours, but it doesn’t update immediately when dataset parameters change. 1

This means that even when you pass parameters via URL, the filter controls will still display values from the default dataset context.1 2

To work around this issue, you have a few options:

  1. You can add parameter values directly to your URL to have the page load with predetermined parameters. 2

  2. Consider implementing Row-Level Security (RLS) if the parameter values are user-specific, which would ensure the proper values are displayed in controls. 3

  3. You could try using cascading filters with the “Show relevant values” button to help manage what appears in controls based on parameter selections. 3

  4. For Direct Query datasets, you may need to manually refresh the controls in the control bar for new values to appear after parameter changes. 1

The documentation on refreshing data in Amazon QuickSight provides additional information about managing data refreshes for both SPICE and Direct Query connections. 1 4

1 Like