# Why does my Analysis break when updating Dataset

**URL:** <https://community.amazonquick.com/t/why-does-my-analysis-break-when-updating-dataset/16641>\
**Category:** Q&A\
**Tags:** analysis, quick-sight\
**Created:** [August 4, 2023, 5:42pm UTC](https://community.amazonquick.com/t/why-does-my-analysis-break-when-updating-dataset/16641 "2023-08-04T17:42:13Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![evanbetterc](https://avatars.discourse-cdn.com/v4/letter/e/ebca7d/32.png) [@evanbetterc](https://community.amazonquick.com/u/evanbetterc)\
**Post date:** [August 4, 2023, 5:42pm UTC](https://community.amazonquick.com/t/why-does-my-analysis-break-when-updating-dataset/16641/1 "2023-08-04T17:42:13Z")

</div>

I’m working on a prototype for Dataset, dashboard and Analysis promotions. To simulate any changes in dataset schemas, I need to ensure nothing breaks if something is updated.  
Running into the below, where analyses and dashboards break when updating a dataset. However, the only change to the dataset was adding columns, nothing was taken away.

```auto
"Column that used in the field can not be found in Dataset"

```

That column does exist in the dataset, yet my analyses can’t find it. Why is this? Does the analysis refer to a static index of the column vs. re-fetching after a dataset update?

Thanks,  
Evan S.

---

<div class="post-metadata">

**Author:** ![SD\_QS](https://avatars.discourse-cdn.com/v4/letter/s/df705f/32.png) [@SD\_QS](https://community.amazonquick.com/u/SD_QS)\
**Post date:** [August 5, 2023, 9:11am UTC](https://community.amazonquick.com/t/why-does-my-analysis-break-when-updating-dataset/16641/2 "2023-08-05T09:11:01Z")

</div>

Hi @evanbetterc Could you please confirm that all the columns that previously existed have the same column name and data type?

> - When you edit a dataset, try not to make changes that might break existing visuals. For example, don’t remove columns that are being used in a visual. If you must remove a column, create a calculated column in its place. The replacement column should have the same name and data type as the original.

From the documentation here: [Changing datasets - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/change-a-data-set.html)

---

<div class="post-metadata">

**Author:** ![Sanjeeb2022](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/sanjeeb2022/32/20947_2.png) [@Sanjeeb2022](https://community.amazonquick.com/u/Sanjeeb2022)\
**Post date:** [August 5, 2023, 11:14am UTC](https://community.amazonquick.com/t/why-does-my-analysis-break-when-updating-dataset/16641/3 "2023-08-05T11:14:56Z")

</div>

Hi @evanbetterc - Please ensure the column which is deleted are NOT part of the any analysis and also @SD_QS correct, please ensure there is NO change in the column names or else it will throw an error.

Regards - Sanjeeb

---

<div class="post-metadata">

**Author:** ![evanbetterc](https://avatars.discourse-cdn.com/v4/letter/e/ebca7d/32.png) [@evanbetterc](https://community.amazonquick.com/u/evanbetterc)\
**Post date:** [August 21, 2023, 7:24pm UTC](https://community.amazonquick.com/t/why-does-my-analysis-break-when-updating-dataset/16641/4 "2023-08-21T19:24:31Z")

</div>

The column names are the same, what I observed was when creating the dataset manually and updating via the API, some config or mapping broke… I couldn’t figure it out, but when I went all API it updated properly. Thanks!