We have a Quicksight report, up until recently we had a schedule that would run everyday that would export all the data from a table and email the CSV file.
However, since 24 April 2024 no additional data has been included in the daily CSV file. The new file also does not include data from the months of August to November of 2023, some other data fields are missing that weren’t missing before. The emailed file is 1,000KB.
The data in the Quicksight table is up to date and correct and has data from every day after the 24th of April. When the CSV is generated manually by clicking on the table the CSV that is created is correct and up to date.
What we have tried so far:
- republishing the dashboard - no change,
- creating a new schedule - no change,
- removed filter end dates - no change,
- thought the document size was too large, but Quicksight has a max of 4GB for emails
I am unsure of what else could be causing the data being generated by the schedule to be incorrect.