Is this datasource on Server or on Desktop?
The query (no data) is stored as a Server Data Source. Then I connnect a desktop workbook to the Tableau connection Data Source. It allows me to extract the data, but only to a local copy. I want to extract the data on desktop and then save this data back on Tableau Server. Since we have a 2 hour limit on Tableau Server, the extract can not run there, it has to run on desktop. But it never gives me the option to publish to server.
Oh, the original data is the Tabmon database which is located on our licensing server(Primary)
You can create extracts via Tableau Server. This would be your best option as you can set a refresh schedule:
See if this helps: Extract Your Data
However, currently, you can right click the data source in Desktop > Create Extract.
Wait for it to finish, Then you can upload the Extract to Server.
Hope this helps!