Has anyone been able to setup a refresh or even have Manual Refresh for Shared Excel source connection from Network Drive

Hello,

I am looking out potential options or feasibility to schedule a refresh or even a manual refresh of Excel data source mounted on Network Drive .
Appreciate your inputs.

Thanks
Gaurav

Hi,

our engineers created a lambda, that imports an excel file from a sharepoint location to our s3. Afterwards we convert it to a csv or parquet file. With Athena we get the table and can upload it as a dataset to Quicksight.

With eventbridge you can schedule the lambda.