Error while re-uploading Dataset in quick portal

Q&A
, , , ,
1

I had developed a very simple dashboard using an excel file as a dataset. This dashboard was working well even when I made some changes in the excel file and reuploaded. However, now when I made some changes and reuploaded I am getting this error - “Unable to update the dataset. If the issue persists, please contact the QuickSight support”. The columns in the excel file are same as earlier.
Can someone please help? Or maybe share the CTI for raising the ticket with QS support for Amazon employees?

2

Hi,

This error typically occurs when there’s a discrepancy between the file you’re reuploading and what QuickSight expects from the original dataset. Even if the columns appear the same, there are a few things to validate:

Validate the File Being Uploaded:

  • The new file must have the same fields in the same order as the original file currently in the dataset.

  • Any field discrepancies can cause the update to fail silently with no preview.

  • New fields should only be appended after the original fields.

  • Supported file formats: CSV, TSV, ELF, CLF, JSON, and XLSX.

Reference: Updating files in a dataset - Amazon QuickSight

Additional checks:

  • Try creating a brand-new dataset from the updated file to see if the issue is with the update mechanism itself.

I will share the CTI with you internally.

Regards,