KNOWLEDGE BASE

Automating Tableau Online Extract Refresh Tasks Using Windows Task Scheduler


Published: 07 Apr 2015
Last Modified Date: 03 Jan 2020

Issue

When trying to refresh extracts using Windows Task Scheduler, the extract may not refresh successfully. 

Environment

  • Tableau Online
  • Windows Task Scheduler 

Resolution

  1. Open a text editor and use the following script for the correct directory and command to execute (replace <version> with the Tableau Server Version.
    @echo on
    	cd "c:\program files\tableau\tableau <version>\bin>"
    	tableau refreshextract --server https://online.tableau.com --username test@gmail.com --password password --site sitename --datasource "datasource_name" --source-username dbname --source-password dbpassword
  2. Save it as a bat file with the .bat extension 
  3. Create a new task in Windows Task Scheduler for running the .bat file. 
Did this article resolve the issue?