If the workbook is connected to the extract that is published to the server, i.e. using the Data Server feature, then the connection between the workbook and the published extract is always live, there is no way (or need) to refresh it. The refresh function is performed by the extract, i.e. the extract can be scheduled to get refreshed or refreshed manually, and any workbook that uses it will automatically get the latest data on connection.
I had a similar question to Robert's. I arrived at the conclusion that you have provided, so here is my question. I appears that after I publish the workbook (using the server published data source w/ scheduled extracts), that I have to manually refresh the workbook when I log in, as opposed to it being a direct connect. Is that because I'm not somehow connecting live?
Did you ever get any feedback on this issue?
I believe I am seeing the same thing.
I am using the "tableau refreshextract" via a windows scheduled task which is working successfully but each time I open the workbook (which was published with a connection to the published data source) I have to refresh the workbook to see the most recent data?