Once the data source has been published as Live connection (embedded or not) on the server, it is not possible to convert it into Extract. As of now, one need to re-publish the workbook using Tableau Desktop. At times, it consumes a good amount of time and re-sources on user's computer. It would be great if this feature can be made available on server. Publishing of live connection is quicker than extract. This can also benefit admins if they notice heavy usage of a live connection and convert it into Extract on the fly to save database query & time.
--> Community Manager update [Ciara Brennan]
Also refer to Duplicate idea #4755
https://community.tableau.com/ideas/4755 ( 30 Votes )