This is how you can automate the reports: while publishing the report to Tableau server, you will find the option to schedule reports. Click on this to select the time when you want to refresh the data.