2 of 2 people found this helpful
You cannot edit published data sources on the server. You would need to first "download" the published data source into Desktop and change the join definition there and then republish as new or overwrite existing published data source.
The way we do it at my site is that we have a "data source" workbook wherein we make and publish the data source. Then multiple workbooks can link to that data source. So yes, you can reuse a data source in multiple workbooks.
And if changes need to be made to that data source, it's done in one place, and it will apply to all the workbooks that hook to the data source.
So to start up a new workbook and hook an existing data source to it, when you are in a workbook, click "Data" from the top strip menu and select "New Data Source". You get a pop-up box that lets you pick the type of data source: Excel, Text, Tableau Server, etc. Pick one and then satisfy all the questions it asks. (Path name, server name, etc.) And off you go!
Thanks John for this answer. I will give this a try.
Also, do you have any insight on my second question? Reusing the same data source for multiple workbooks? Can this be done? If yes, how do I create a work book and then choose an existing datasource?