KNOWLEDGE BASE

Disabling Automatic Refreshes on Published Dashboards


Published: 11 Mar 2014
Last Modified Date: 15 Nov 2016

Question

How to disable automatic refreshes of published views or change the refresh frequency.

Environment

Tableau Server

Answer

Option 1: Pause automatic updates

For more information, see Pause Automatic Updates in Tableau Help.

Option 2: Increase the VizQL server timeout value

Warning: Increasing the timeout value can have negative effect on the performance of Tableau Server. Increasing the minimum value might result in Tableau Server running out of memory.
  1. On the computer running Tableau Server, open the Command Prompt as an administrator, and run one of the following commands:
    • On a 32-bit computer: cd "C:\Program Files\Tableau\Tableau Server\<version>\bin"
    • On a 64-bit computer: cd "C:\Program Files (x86)\Tableau\Tableau Server\<version>\bin"
  2. At the command prompt, run the following commands in order:
    • tabadmin stop 
    • tabadmin set vizqlserver.session.expiry.timeout:<minutes>
    • tabadmin set vizqlserver.session.expiry.minimum:<minutes> 
    • tabadmin start 
and replace <minutes> with a specific number of minutes. 

Additional Information

  • The default minimum value is 5 ; the default timeout value is 30. For more information, see tabadmin set options in Tableau Help.
  • If the computer running Tableau Server runs out of available memory, sessions that have been running longer than minimum are terminated to free up memory. 
  • After the timeout time, Tableau Server refreshes published dashboards to free up RAM. Increasing the timeout value will allow more VizQL sessions to exist per process. Views won't be refreshed as often. Monitor the available resources on the computer running Tableau Server to ensure adequate free RAM. 
  • There is a higher risk of running out of RAM if you are running the 32-bit version of Tableau Server.
  • To increase the stability, add RAM to the computer running Tableau Server.
Did this article resolve the issue?