1 of 1 people found this helpful
I assume you are using Tableau Server (if not you cannot schedule an auto refresh in desktop)
You cannot get Tableau to dynamically increment the datasource name so you will need to ensure that the csv file you import always has the same name and filepath for example "c:\daily updates\data.csv"
Tableau Server would always look for the file "data csv".
Once you are sure that that Tableau Server can see the csv file and refresh the data you just need to set a scheduled task to update the Tableau workbooks some time after the original batch file runs.
Yes, I'm using Tableau Server, and I always have the same file name in my server folder.
How can I create a scheduled task to update Tableau Workbooks?
It depends on how you are connecting to the data. If you are using extracts then in Desktop when you click publish to server you will be given a message box with some options.
In the bottom corner there is a button for Scheduling and Automation. Open this and choose the frequency at which to refresh data.
If you are connecting live you do not need to do anything other than refresh the web page you are viewing the report on - changes in the data should be bought into the Tableau reports in real time.
All of this should be in the online help on the Tableau website or in the Admin Guide:
As you are using csv files I would recommend creating Tableau Data Extracts before publishing to server. csv files are locked when being viewed or accessed by an application and this may affect your ability to update the data.