Quicksight Report Refresh based on secondary Dataset Refresh

Question & Answer
, ,
1

I created one Dataset using PostgreSQL and import another Dataset from different
PostgreSQL Data Source acted as secondary Dataset. I scheduled refresh for that primary dataset as once a day and for secondary as in every 15 minutes incremental and join those two Datasets (because incremental refresh is not working for Dataset with two different sources) but when I upload data to secondary dataset , I can see joined data updated in primary one but It’s not reflecting in Quicksight Dashboard. Is there any way that I can trigger secondary data refresh resulting in Dashboard changes?

1 Like
2

Hi @manthansanjayp - Thanks for the question. If I understood the problem, you are able to see the updated data in the dataset page ( after the join) and also able to see the changes in the analysis ( Please verify this also) but not able to see the updated data in the dashboard? Can you please check the below link - Auto dashboard page refresh

Regards - Sanjeeb

3

Hi @Sanjeeb2022 ,

I can see updated records in dataset after refreshing dataset page but Analysis and Dashboards are not reflecting this updated records. After doing full refresh of this primary dataset I can see those records in Analysis and Dashboards.

4

Hi @manthansanjayp - Interesting. Is it possible to raise a ticket to AWS Customer support team so that they can do a deep dive and provide the right solution approach.

To raise a request, please follow the link - Creating support cases and case management - AWS Support

Regards - Sanjeeb