QuickSight Dataset Refresh Failing, Causing Missing Fields in Visuals

[Giridhar.Prabhu]

Hi @kaivanwadia

When you remove a table in the Dataset it has an impact on the fields used in the Analysis. So, even if you restored a table with same names and saved the dataset, the visuals have already lost reference to the field and show as missing fields.

Your dataset refresh issue also looks similar. But I am surprised QuickSight allowed you to delete the older dataset if it was being referred in another dataset.

I am not sure if it applies to your case; but you were changing the source of your data you could probably use DescribeDataset and UpdateDataset CLI commands as described in the following post

Changing Data Source for a Dataset

Hi @dan.kainz - It sounds like you could be looking for 1 of 2 things. If you need to update the DataSource connection properties you can follow the steps outlined here Editing a database data source. Updating the DataSource used by a DataSet. This is not currently possible in the UI. As a workaround, you can update the DataSet using the QuickSight API. The rough process; DescribeDataset a. Update the property DataSourceArn to your new DataSource Arn UpdateDataset

Regards,
Giri