Dashboard opens with data but filters show error "Request took too long. try again later"

Question & Answer
,
12

Hi @Ali_B
Some things to check:

  1. How many distinct values are in the fields? Is it a large number that’s causing the performance issue? Also how many rows are in the SPICE dataset.

I believe there are a few options to solve this.

  1. As @ErikG mentioned ‘only show relevant values’ will cut down the number of values returned in the filter list.

  2. Change the control to ‘Dropdown - multiselect’ so it’s not preloading every value in the dropdown.

  3. Create a dataset specifically for the filters/controls that only contains a unique list of values. Outlined here: Improve Filter performance for Direct Query Dashboards: 2023 Amazon QuickSight Learning Series