As per my knowledge there is no option to change the data source thru workbook - Edit on the server. Using Original Desktop version and publish again or Downloading workbook to your local PC as Desktop version will be a good approach to address these kind of issues.
1 of 1 people found this helpful
Thats why you need to use published data sources concept/feature here.
I documented How/Why/What/When about the Tableau Published Data Sources.
Please feel free to go through the document and let us know for any further queries.