Automting excel file for Quicksight

My user has data in excel file. He provides new excel every morning. How to automate this for every morning dashboard refresh ?


you can use schedule refresh of QS. It will work as you set it.


@Naveed This will not work with an excel file.

@chrdttchavan you either need to establish an ETL for this excel file or replace the file manually in quicksight.
For the ETL: Your user could edit the excel file in sharepoint. You move this file with an Lambda to S3, convert it to an csv file (or parquet) and then you can set up a schedule in quicksight or create a step function with an S3 Trigger, so it starts when the file is updated. With the Step-Function you can create an ingestion for a specific dataset.

1 Like