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.
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.
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
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
