Automatically Upload data to QuickSight Dashboard/datasets (Excel)

Hi,

I am looking for a solution to automatically update/ingest the data to Excel dataset.

Problem:
In legacy, we have a dashboard in which we are manually entering the data in UI with a submit button, when submitted the data gets added to the table and dashboard.

As part of migration to QuickSight, UI has been decommissioned.
I am not able to find an option to manually enter the data from QuickSight Dashboard, that can get added to the database table or QuickSight dashboard itself.

From the available Quicksight resources, I see we can do it by uploading the data in an Excel file and manually update/upload every time when we get the new data(daily), which is not suggestable as it is error prone.

I have also seen this process in the below link:
Again here also I need to manually ingest the data to the excel file, which is stored in S3 instead of my local.

Appreciate, if there are any options or suggestions on this.

Hey @praveen.gp

You are correct that QuickSight doesn’t have this functionality. To do this you would need to embed your dashboard into an application and then have your application manage adding the data similar to the blog post you linked.