Admin console/datasets only showing 3 months of data

Question & Answer
,
1

I have an admin console working in quicksight, but am noticing it’s only getting data from the last 3 months. Is there a reason for this limit? I can’t find where to increase this limit. The data is being drawn in from a lambda function, then queried by Athena into quicksight if that helps anyone figure this out. Thanks!

2

can share where is the data source, can check if it has more than 3 months data?
can check if any filter was applied in the dashboard or the dataset?
assume you are using SPICE, are you using full data refresh or incremental refresh?

3

There is no filter on the dataset or dashboard. When I try to filter to for example January, there’s no data. Yesterday it had data up to June 8th, today the earliest is June 9th. It is a full refresh schedule. I will check the datasource.

4

Yes, the datasource has data more than 3 months ago

5

if no filter was applied in dataset, suggest trying to create a table in analysis and see whether you can see the old data in there.

If not, suggest raising a support ticket

6

I can’t see the old data, I can create a ticket. I just wanted to check here first, thanks.

7

thanks @ineedqshelp, one other reason can be… if you are using custom SQL in dataset, there is a condition applied in the SQL

2 Likes
8

Yes, that was the issue, I found it in the SQL, thank you!

1 Like