# Visual Error Message, Can't load all the data

**URL:** <https://community.amazonquick.com/t/visual-error-message-cant-load-all-the-data/3341>\
**Category:** Q&A\
**Tags:** analysis, quick-sight\
**Created:** [April 29, 2022, 6:45pm UTC](https://community.amazonquick.com/t/visual-error-message-cant-load-all-the-data/3341 "2022-04-29T18:45:20Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![selamlt](https://avatars.discourse-cdn.com/v4/letter/s/6de8d8/32.png) [@selamlt](https://community.amazonquick.com/u/selamlt)\
**Post date:** [April 29, 2022, 6:45pm UTC](https://community.amazonquick.com/t/visual-error-message-cant-load-all-the-data/3341/1 "2022-04-29T18:45:20Z")

</div>

I have a pivot table that was displaying data just fine, but now unless I use a control to filter data by region or year, quicksight is failing to load all data. The query runs and refresh with out any failures.

---

<div class="post-metadata">

**Author:** ![cgreenacre](https://avatars.discourse-cdn.com/v4/letter/c/8dc957/32.png) [@cgreenacre](https://community.amazonquick.com/u/cgreenacre)\
**Post date:** [April 29, 2022, 10:53pm UTC](https://community.amazonquick.com/t/visual-error-message-cant-load-all-the-data/3341/2 "2022-04-29T22:53:09Z")

</div>

What is the duration between opening the dashboard and the error message appearing?

---

<div class="post-metadata">

**Author:** ![selamlt](https://avatars.discourse-cdn.com/v4/letter/s/6de8d8/32.png) [@selamlt](https://community.amazonquick.com/u/selamlt)\
**Post date:** [May 1, 2022, 4:04am UTC](https://community.amazonquick.com/t/visual-error-message-cant-load-all-the-data/3341/3 "2022-05-01T04:04:37Z")

</div>

1-2 mins. It starts to load and then Visual error message pops up.

---

<div class="post-metadata">

**Author:** ![cgreenacre](https://avatars.discourse-cdn.com/v4/letter/c/8dc957/32.png) [@cgreenacre](https://community.amazonquick.com/u/cgreenacre)\
**Post date:** [May 3, 2022, 2:22pm UTC](https://community.amazonquick.com/t/visual-error-message-cant-load-all-the-data/3341/4 "2022-05-03T14:22:15Z")

</div>

Would this be the error message?  
 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/d/dc91cb12f93df32c355a0044f668cbcc15492956.png)  
If so, **start thinking** about simplifying the analysis, or removing columns from the dataset, or removing rows from the dataset. I’ll let others explain why.  
We ran in to this when we expanded our spice dataset to include the pre-covid year, so that we could do YoY comparisons that included a “normal” year.

---

<div class="post-metadata">

**Author:** ![Max](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/max/32/2288_2.png) [@Max](https://community.amazonquick.com/u/Max)\
**Post date:** [October 17, 2022, 9:41pm UTC](https://community.amazonquick.com/t/visual-error-message-cant-load-all-the-data/3341/5 "2022-10-17T21:41:37Z")

</div>

Hey @selamlt We have not heard back from you regarding your question. We would still like to help. If we do not hear back in the next 7 days, we will archive the question.

---

<div class="post-metadata">

**Author:** ![Max](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/max/32/2288_2.png) [@Max](https://community.amazonquick.com/u/Max)\
**Post date:** [November 1, 2022, 3:50pm UTC](https://community.amazonquick.com/t/visual-error-message-cant-load-all-the-data/3341/6 "2022-11-01T15:50:48Z")

</div>