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.