Don't publish it as a twbx. Instead publish it as a twb file. A twbx file is really a zip file that includes copies of all the resources that Tableau needs to create the viz. Note I said "copies" of the files. So you're packaging up a copy of the extract that no longer has any tie-back to the original data source. When you publish a twb file, you're only publishing the viz with links back to the extract, which maintains a link back to the original data source. So when you refresh the extract on a schedule, Tableau goes back to the original data source and re-extracts (or appends) the data.
The "Run Now" does just that, runs the extract you've selected. In my example, I selected "Incremental refresh" and if I were to click the "Run Now" option that incremental refresh task would execute immediately.
The "Run Now" is not a schedule, it is a way to force a task to run NOW for a specified object, in the above case, the incremental refresh of only the Virtual Technician workbook.
...and remember that the path you use to connect to the database on the Desktop must be accessible from the Server.
In other words, don't connect to c:\mydatabase.mdb or (mapped drive) z:\mydatabase.mdb. Instead, connect to it like this: \\someMachineName\SomeShareName\mydatabase.mdb
The Tableau RunAs user must have access to this share.
Thanks for the response,
Where do i map my network drive for the future update
I tried to put details at the time of publish - i got a box, with name of the extract - it does not ask to enter any credentials
it is not asking me path or user name or password
BTW, i connect to database using network drive, here is what i do
Tableau - connect to DB using MS Access - Browse - goes to Network drive - open specific Database - bring table (s) in Tableau - create extract and work using that
I am confused about where to give path - so server can find and refresh files automatically
I was saying you DON’T want to use mapped drives. For example, the mapped drive Z: on your computer may point to
…however that mapped drive very likely DOESN’T exist on Tableau Server…so when the Server tried to go after the database in Z:, an error will result. Therefore, you want want to use a UNC path which all machines will understand all the time.