I'm setting up a Dashboard on Tableau Server and with a data source extract from Google Analytics.
I would like it to refresh hourly.
When publishing the data source I have selected Fixed start and incremental refresh, and i can see that the end date is hardcoded to yesterday and I can only schedule update once a day.
This means that my Dashboard will only have data for the previous day. Is this a known limitation? Is there a way to achieve hourly automated data refreshes?
I thought of three possible solutions:
1) Using command line data extract update, but I don't see any parameter that allows me to control date range, so the end date would always be hardcoded to yesterday (?)
2) Using Tableau API. But again, my extract will only refresh to latest day yesterday.
3) Setting up a separate process to download the data into a database and then connect to it with Tableau. Not sure if in this case I will be able to incrementally update the extract or if I have to reload the entire extract all the time.