# Query works in SPICE but not Direct Query mode

**URL:** <https://community.amazonquick.com/t/query-works-in-spice-but-not-direct-query-mode/50418>\
**Category:** Q&A\
**Tags:** qls-spice, direct-query, amazon-quick, Business-Intelligence-Engineer, quick-sight\
**Created:** [November 5, 2025, 1:33pm UTC](https://community.amazonquick.com/t/query-works-in-spice-but-not-direct-query-mode/50418 "2025-11-05T13:33:18Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![alvarosuarez](https://avatars.discourse-cdn.com/v4/letter/a/ecae2f/32.png) [@alvarosuarez](https://community.amazonquick.com/u/alvarosuarez)\
**Post date:** [November 5, 2025, 1:33pm UTC](https://community.amazonquick.com/t/query-works-in-spice-but-not-direct-query-mode/50418/1 "2025-11-05T13:33:19Z")

</div>

I have a SQL query that I want to publish and visualise. SPICE is the default query mode but I’d prefer to ‘Publish & visualise’ with ‘Direct query’. However, when I do this I get the error message:

”_ **Cannot publish datase. Unable to update the dataset. If the issue persists, please contact the QuickSight support.** _”

This wasn’t an issue in the previous version of Quick, when it was still Quicksight (EU-WEst-2 London). Can anybody help me understand why I am getting this error message?

Thanks.

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/2/3/230249b379e327721d1dac6badb8b7a21381bde1.png)

---

<div class="post-metadata">

**Author:** ![Xclipse](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/xclipse/32/20455_2.png) [@Xclipse](https://community.amazonquick.com/u/Xclipse)\
**Post date:** [November 5, 2025, 5:18pm UTC](https://community.amazonquick.com/t/query-works-in-spice-but-not-direct-query-mode/50418/2 "2025-11-05T17:18:55Z")

</div>

Hi @alvarosuarez

Welcome to the Quick community!

Could you please share what data source is being used in the dataset?

Since your query works with SPICE, could you try creating a new dataset using the same query but with Direct Query mode enabled and see if that works.

Please refer to the below documentation this might be helpful for you.

> **[Best practices for Amazon QuickSight SPICE and direct query mode | Amazon Web...](https://aws.amazon.com/blogs/business-intelligence/best-practices-for-amazon-quicksight-spice-and-direct-query-mode/)**
>
> In QuickSight, data is queried from datasets when visuals load within analyses, dashboards, reports, exports, in responses to questions asked in natural language to Amazon Q, or when threshold alerts are being evaluated. Direct queries are sent to...

---

<div class="post-metadata">

**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\
**Post date:** [November 18, 2025, 9:31pm UTC](https://community.amazonquick.com/t/query-works-in-spice-but-not-direct-query-mode/50418/3 "2025-11-18T21:31:19Z")

</div>

Hi @alvarosuarez,

Following up here as it’s been awhile since we last heard from you on this thread; did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you

---

<div class="post-metadata">

**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\
**Post date:** [November 21, 2025, 4:16pm UTC](https://community.amazonquick.com/t/query-works-in-spice-but-not-direct-query-mode/50418/4 "2025-11-21T16:16:57Z")

</div>

Hi @alvarosuarez,

Since we have not heard back further, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.

Thank you