can i edit the tableau metadata tables and update it manually in _dataconnections and _datasources? would that solve the issue.
my version of tableau is 8.2.2 and i have created an external account and I am not sure if i have update privileges
Not sure exactly what you're trying to do but did you read this? onlinehelp.tableau.com/v8.2/server/en-us/help.htm#connections_modify.htm
I do not recommend messing around with the tables in the Tableau Server db and, if you do, Tableau Support will not be able to help you if things break!
Thanks Toby for the reply. But in the data connections i dont get an option of database name. Last week my server team has changed the database name so I tried to edit the data connections but its of no use. I will republish the worksheets manually.
Well, that wasn't very nice of them!
I believe that if you were to change the entries in the Postgres db they wouldn't match with what's in the report XML, so re-publishing is what needs to be done