How to automate reports using Tableau software?

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.