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

Question & Answer
,
1

This error happens when I open the dashboard. it works fine from the analysis.

Dashboard:

image
image1100×614 36.4 KB

Analysis:

image
image1367×677 52.1 KB

2

Hi @Ali_B ,
what is the exclamation mark telling?
BG

3

image

image

The data in the main table loads fine. it just the filtes.

4

can you try to publish with a specific element instead of “all” on the filter?

5

it works for a while, then users start seeing the same errors. When I first published the dashboard, it worked fine even without preselected values. then after a day or so it started showing errors

6

Is you dataset growing or was changed in the meantime?

7

The dataset is definitely growing, it is also being worked on although those filter fields are the same.

8

Because it seems there are to many data or the query is not performing well.

9

The dataset is on SPICE though. I’m not sure what the “query performance” means when your data is loaded in memory on SPICE

10

Ok. In case of SPICE its not relevant.

Are the filter cascading or standalone? I would try to check if i can downsize the elements in a filter and see if it will work.

11

@ErikG By cascading do you mean the “only show relevant values” option on filters? then they are standalone.

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