1 of 1 people found this helpful
Hi Ram –
When you publish a workbook, Tableau takes a “snap shot” of the data and embeds the data into the Packaged Workbook (.twbx ). Deleting the excel file from the shared location will make no difference because the published workbook is using the data published as part of the .twbx .
Q1 response... If you want a live connection to a published data source you will have to publish both the workbook and the data source and link to the published data source from the desktop. You will know you are connected to the published data source as you will see this icon in the Data Pane in the workbook. The following help file will step you through the process:
Q2 response… Once you have connected to the data source that is already published to the server, you will need to publish the workbook. Next select the “Data Sources” on the server this will yield the connected workbooks.
Ultimately published data sources are independent of the workbook until you connect them. Additionally, your workbooks in Desktop can be connected to local data files or server data OR published data sources. Using these different data connections within a workbook can be accomplished by using Tableaus “Replace Data Source”. The following tutorial provides a great resource for how and why to do this…
Hope this is helpful…