I have put the datasets on Quicksight on daily refresh at a specific time in the morning, but sometimes the tables are updated little later than the dashboard refresh time due to which users have to wait until next day morning for the updated data. Is there a way dashboard can be set to automatically refresh as soon as the data tables are refreshed/updated (like Live version in Tableau)?
I think your options are:
- Use direct query instead of spice
- or if you need to use SPICE, disable the scheduled refresh and make sure to create a new ingestion using createIngestion api call when the underlying tables have finished updating.