After adding the account names all quicksight visuals showing "The dataset changed too much for QuickSight to automatically update your analysis"

Question

I followed the steps to add the account names to my CUDOS dashboard like described here: https://catalog.workshops.aws/awscid/en-US/dashboards/foundational/cudos-cid-kpi/add-accounts I used Option 1. I created the view in Athena and received successfully the account names. 
Then I changed the summary_view dataset to use the new view from optimized data instead from the cur. 
After the refresh all my CUDOS Dashboard crashes with the error message. 
"The dataset changed too much for QuickSight to automatically update your analysis. You can edit the fields or filter in the current dataset, or replace it with different dataset"
A roll back by using the original account id's did not solve the problem.

Any hint?

Thank you.

Andreas Krueger · Answer

It seems some columns in the new dataset are missing. I set back the Dashboards to the factory settings, this solves my problem.

re:Post Agent · Answer

The error message you're encountering suggests that the changes made to your dataset were significant enough that QuickSight couldn't automatically update your analysis. This can happen when there are substantial differences between the original dataset and the new one, such as changes in column names, data types, or the overall structure of the data.

Here are some steps you can take to address this issue:

1. Check field mapping: When replacing a dataset, QuickSight attempts to map fields from the old dataset to the new one. If there are mismatches, you may need to manually update the field mapping. Look for any warnings about mismatched or missing columns when replacing the dataset.

2. Review the new dataset: Ensure that the new view you created in Athena has all the necessary columns that were present in the original dataset. Pay special attention to column names and data types.

3. Replace the dataset: Instead of trying to update the existing dataset, you might need to replace it entirely. In the analysis, go to the Data pane, expand the Dataset dropdown, choose "Manage datasets," select the ellipsis next to the dataset you want to replace, and choose "Replace." Then select your new dataset.

4. Update visuals manually: If automatic updates fail, you may need to manually update your visuals. This could involve recreating some charts or adjusting field selections in existing visuals.

5. Check calculated fields: If you have any calculated fields in your analysis, ensure they are still valid with the new dataset structure.

6. Verify data freshness: Make sure your new view in Athena is up-to-date and contains the expected data.

If these steps don't resolve the issue, you may need to create a new analysis using the updated dataset and rebuild your visuals. While this can be time-consuming, it ensures that your analysis is fully compatible with the new data structure.

Remember to always back up your original analysis before making significant changes, so you can revert if needed.

If the problem persists even after attempting these solutions, you may want to contact AWS support for further assistance, as there could be underlying issues with the dataset or QuickSight configuration.
      
**Sources**  
[Replacing datasets - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/replacing-data-sets.html)  
[Adding a dataset to an analysis - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/adding-a-data-set-to-an-analysis.html)  
[Refreshing data in Amazon QuickSight - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/refreshing-data.html)

After adding the account names all quicksight visuals showing "The dataset changed too much for QuickSight to automatically update your analysis"

Relevant content