I have dashboard with Multiple tabs. Each Tab is having Pivot table and it have some rendering time. When the visual is loaded in One Tab , & navigate to next tab and again come back to first tab, again its having some rendering time.
Ie, Each time when we open a Tab, its taking time to Load. But the expectation is Once a dashboard is loaded, whenever we change the tabs and come back again, it should not be having any loading . Please provide some feedback on this like how can we avoid this
Hi @Ganga
QuickSight only keeps the visuals for the sheet that is currently visible in browser memory.
If the author turns on Edit → Analysis Settings → “Reload visuals every time I switch sheets”, the engine will deliberately re‑query and re‑draw every visual each time you change tabs, which is exactly the behavior you’re seeing.
With that toggle off (the default), a sheet stays cached for about 30 minutes, jumping away and back is instant because QuickSight serves the stored result instead of re‑querying.
Please refer to the below documentations this might be helpful for you.
Hi @Ganga
Could you please confirm whether the dataset uses SPICE or Direct Query? If it’s in Direct Query mode, each visit triggers a live query, so you’ll still have to wait for the database.
Large pivot tables also take time for the browser to render, even when the data itself is cached.