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.

You need to publish report to tableau server, while publishing you will find one option to schedule reports. You just need to select the time when you want to refresh data.