If I understand well our problem, when a scheduled export as CSV fails for a specific gadget while others on the same dataset and dashboard work fine, there are a few potential causes to investigate according to QS documents
Check the Gadget’s Configuration:
Ensure that the gadget (visualization) is properly configured and does not have any unsupported features for CSV export. For example, certain visualizations or calculated fields may not export correctly.
Dataset Permissions:
Verify that the dataset used by the gadget has the correct permissions and is accessible by the schedule. If the dataset has restricted access, it might cause the export to fail.
Filters and Parameters:
Check if the gadget has specific filters or parameters applied that might be causing the export to fail. For example, if the gadget is filtered to a state where no data is returned, the export might not generate a file.
Data Size and Complexity:
If the gadget is working with a very large dataset or complex calculations, it might exceed the limits for scheduled exports. Try simplifying the gadget or reducing the data size to see if the issue persists.
Error Logs:
Check the Quick Sight logs for any error messages related to the failed schedule. These logs can provide more specific details about why the export is failing.
Recreate the Gadget:
As a last resort, try recreating the gadget from scratch. Sometimes, a configuration issue or corruption in the gadget can cause unexpected behavior.
There is some others support documentations about this topic:
Really hope this suggestions helps you! Please, let me know!
Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.