the load time for most visuals in this dashboard takes a long time, but now i keep getting this error. any tips to resolve this?
Hi @chrhogya and welcome to the community!
This is a query timeout, even though SPICE is generally fast, it can still time out when a visual is doing heavy computation. And as per my understanding, the timeout for visuals is a hard QuickSight limit and can’t be increased, so the fix has to come from optimizing the query itself.
Some potential workarounds I’d recommend are simplifying the visual, if your visual has many dimensions, calculated fields, or aggregations stacked together, try reducing complexity. Break it into smaller visuals if possible. (For example, if you have a table with 20 huge calc fields in it, you can try to break them up into 2 tables with 10 each and then group the tables together).
I’d also recommend checking your calculated fields, things like countOver, sumOver, and nested ifelse with large partitions are a common cause of SPICE timeouts. If you have any level-aware aggregations or heavy rollups happening at the visual level, try moving that logic into the dataset preparation instead (SQL or SPICE transforms) so the visual is just displaying pre-computed values rather than crunching them on the fly.
Hope this helps and feel free to reply with any updates or additional questions regarding this situation.
Hi @chrhogya ,
Just checking back in since we haven’t heard from you in a bit. I wanted to see if the guidance shared earlier helped resolve your question, or if you found a solution in the meantime.
If you still have any additional questions related to your initial post, feel free to share them. Otherwise, any update you’re able to provide within the next 3 business days would be helpful for the community.
Thank you
Hi @chrhogya ,
Since I haven’t received any further updates from you, I’ll treat this inquiry as complete for now. If you have any additional questions, feel free to create a new post in the community and link this discussion for context.
Thank you