6 of 6 people found this helpful
In your above example with A, B, C, D, the workbook refresh option (within the server interface) will only be enabled when there is an extract within the workbook to be refreshed, otherwise the refresh option will be grayed out. In your case, there is an extract available to be refreshed (source A), and the workbook refresh will take care of A and A only.
Datasource D (published extract datasource) will need to be scheduled as a separate task as the workbook is just pointing at the published datasource.
I agree with@JEFF STRAUSS. You should have data extract connection to perform automatic refresh.
4 of 4 people found this helpful
Hi Sunil Tikar
Question 1: Agreed wit Jeff Strauss
Question 2: Datasource Refresh : This is possible only when you publish the datasource to your Tableau server. On top of it, You build the Workbooks by using this published datasource.
It will be a single source of truth for all your workbooks using the data that is coming out of your published data source.
Workbook Refresh : This is possible only when you embed the datasources in to your workbook and then publish the workbook to the Tableau server.
You need to refresh each and every workbook that is using your datasource. other wise data will be inconsistent , even though you are using same query or datasource in two different workbooks.
Question 3: The only advantage with extracted data source refresh is it can be used in multiple workbooks. where as it's not the case with the workbook refresh.
For more details: You can refer this link http://onlinehelp.tableau.com/current/pro/desktop/en-us/help.htm#publish_overview.html
Please let me know, if it helpful.
Sorry about this but HAS ANYONE TRIED TO CREATE A LIVE CONNECTION AND PUSH IT TO THE TABLEAU SERVER?
Out Of Curiosity! My discussion link Re: Add Live Data Source To Tableau Server From CODE