No data showed on the dashboard

Hello,

Yesterday (12-08-2023) it looked like the people accessing to the dashboard could not see the data for some of the report…the whole account behaved weird…

In the analysis file, everything looked fine but in the dashboard was data disappearing (“NO data” showed), appearing again, then other report within the same dashboard were showing data, then they were not showing data anymore…

the datasets were protected with RSL, and everything was ok. I created a dashboard just for me to test and there everything was working fine o.O.

then I republished the production dashboard and this seemed that fixed the problem.

Can you explain what could happened here so I can try to avoid this from happening?

Spice problem? just to many dataset within the same dashboard (with 15 min scheduled refresh)? I put also the date in case some major maintenance was done in QS.

thank you

Hello @remba87, there definitely seem to be a few moving parts here that could possible cause the issue.

  • Do you have any date time filters or controls added in the dashboard? If so maybe something isn’t set up quite right and sometimes it is trying to filter for values that aren’t there showing any empty dashboard.

  • Is it possible you made changes to the analysis that were not published to the dashboard when the issues started?

  • My final thought is related to the dataset that is behind the RLS for the dataset. Is it being updated on the same schedule? Could there be a column or value in that dataset that might conflict at some point when data is being refreshed?

These are my initial reactions, maybe with a little more information we can find a solution!

Hello @DylanM,

My hypothesis is that we have added quite some data to one dataset used in the analysis, and this created some problem in the dasboard.

It happens some time for example that if some data is added, the filters have to be refreshed otherwise they look like they are loading…then in this case I have to open the filter and refresh the list…this fix trhe problem…I am guessing that this was the same thing for the dashboard…

Otherwise, yes I have filters,
no, did not do any change in the analysis.

thank you for your help

Hello @remba87, in regards to the filter, are you managing the filter with a control that is set to determine the value within the filter or is it a static filter that has certain fields checked and does not allow for user control? It does seem like this could be where the problem is coming from.

Hi @DylanM
I am using normal filter from the field lists…

In addition, just now another weird thing happened: I changed the security group of a test account so it can see different data…I refreshed the page and I could not see any data from the dashboard…

then I went back to the admin account, republish the dashboard and I could see some data in some report in the dashboard but not in all of them. Then I went back to the admin account, republish the dashboard and I could see all the data from all the report…
what I am missing?
thank you

1 Like

@remba87, in regards to the filter, it might help to add a parameter and control that is linked to the dataset and column that you are wanting to filter. Then using the custom filter functionality in QuickSight to set that column value to equal or not equal the value set within the parameter. This should help to sort out any functionality issues on that end.

Another thought I just had, in regards to your scheduled refresh, are you refreshing the whole dataset or is it an incremental refresh to only grab the updates from the previous 15 minutes? Full refreshes will take longer and could cause some lag time in the updates.

As for the security group issue, this issue should probably be in a seperate topic so we can provide answers to both of these questions. There might be an issue with how the security groups are set up, so can you add a new question in teh community for that problem?

@DylanM

I do an incremental refresh every 15 min.
how do I do th efilter as you suggest…If I have to do in between dates, I need 2 parameters…I found more easily to click on the visual I want to filter, then add filter and select the column I want to use as filter…

I will open soon another topic then, thnak you :slight_smile:

1 Like

@remba87 you can create 2 date parameters, 1 for STARTDATE and another for ENDDATE. Make sure you set both up as Datetime data types. For your ENDDATE you can even set the default to a relative date of today to make sure it always defaults to the most recent date. You can even set it to the minute in time granularity since you are refreshing every 15 minutes. It will look something like this:

Then create a control from that parameter that will link to your date field within your dataset. This will allow the users to select both a start datetime and end datetime.

Now set between filter on your the datefield in your dataset where you use the parameter values for STARTDATE and ENDDATE as your start and end filters. Let me know how this works!

Here is an example of how the filter will look:

1 Like

hi @DylanM

Thank you, I understand now. I did it, but not it is difficult to see if this solved the problem since the “bug” I was talking about it does not happen often :slight_smile:

1 Like

Hello @remba87, I can go ahead and mark my suggestion as a solution for now, but if this appears again feel free to add a follow-up and we can try to figure it out!

just curious @remba87 - Did that issue appear again?

The reason I was asking is that I implemented the same solution for one of my clients yesterday, and I wanted to know if you’ve encountered this issue again!

Thank you,
Shravya

Hello @shravya,
to be honest this was a old problem and I do not remembr xD a lot of things has happened since then. So maybe it did not happen again :slight_smile: