Skip to content

[QuickSight] Is it possible to recover a dataset that was accidentally removed from an analysis?

0

Hello, While working in Analysis, I mistakenly deleted a dataset while trying to change it. Is it possible to recover it?

asked a year ago523 views

2 Answers
0

Yes, it is possible to recover a dataset that was accidentally removed from an analysis in Amazon QuickSight, but the process depends on the specific situation.

If you've recently deleted the dataset from the analysis but the dataset still exists in QuickSight, you can replace it within the analysis. To do this, go to the Data pane on the analysis page, expand the Dataset dropdown, and choose "Manage datasets." Then, select the ellipsis next to the dataset you want to replace and choose "Replace." On the "Select replacement dataset" page, choose the dataset you accidentally removed and select it.

However, if the dataset itself was deleted (not just removed from the analysis), the recovery process is more complex. In this case, you may need to restore the analysis using the RestoreAnalysis API operation. This operation can be used to restore an analysis within 30 days of deletion. You'll need the analysis ID and your AWS account ID to perform this operation.

It's important to note that replacing a dataset in an analysis clears the undo and redo history for that analysis. Also, when replacing a dataset, ensure that the new dataset has similar columns to maintain the functionality of your visuals.

If you're unable to see the option to replace the dataset or if the "missing dataset" is no longer showing in the "manage datasets" section within the analysis, you may need to contact AWS support for further assistance.

In the future, to prevent accidental deletions, it's a good practice to regularly save versions of your datasets. QuickSight allows you to save and publish changes to datasets, creating new versions, and you can revert to previous versions if needed.
Sources
Unable to replace deleted dataset | AWS re:Post
RestoreAnalysis - Amazon QuickSight
Replacing datasets - Amazon QuickSight

answered a year ago

0

Hi, Amazon QuickSight offers several options for recovering accidentally removed datasets from an analysis. If the dataset still exists in QuickSight but was removed from the analysis, you can use the "Manage datasets" feature in the Data pane to replace it. Simply select the dataset's ellipsis menu, choose "Replace," and select the removed dataset. Dataset Management guide However, if the dataset was completely deleted, you may need to use the RestoreAnalysis API within 30 days, which requires the analysis ID and your AWS account ID. Analysis Recovery API reference To prevent future issues, it's recommended to save regular dataset versions and use QuickSight's version control features. Remember that replacing a dataset will clear the undo/redo history, and always verify dataset compatibility to maintain visual functionality. If standard recovery methods fail, contacting AWS Support may be necessary for further assistance.

AWS
EXPERT

answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.