I created a new project folder on our Server, and moved a couple dashboards around. I then deleted the old project with the data source (Google Sheets). I then republished the data sources to the respective new projects, but now the workbooks on Server and in Desktop will not function.
Upon reopening the workbook, the first error message comes up, stating:
No datasource '2017-18VacancyTracker_2017-18' found in repository class DataSourceException Unable to connect to the server "noc-tableauda01". Check that the server is running and that you have access privileges to the requested database. Error: Unable to connect to this Tableau Server data source.
Then, after reconnecting to the newly published data source, it returns this message:
not a sql data connection, cannot construct query function
I now have two workbooks that are completely non-functional, with major work stoppage. This is code red! Please assist
Nothing about the workbook or the Google Sheet data source has changed.
Do the local copies of the workbooks work on Tableau Desktop? with local copies of the data source connections (not using published Tableau Server data sources)?
I assume the Server data sources do not work locally for you as well.