Thanks for your reply.
The new owner updated his credentials for the workbook and data source and updated the extract, he didn't republish the workbook or data source.
From Tableau Server admin guide, I found this note:
"If you change the ownership of a workbook or data source that has embedded credentials, the embedded credentials will be deleted. You will need to download the workbook or data source, update the embedded credentials for the new owner, and then re-upload the workbook or data source."
So what I understood here is, since the current owner of the workbook & data source didn't republish them with his credentials, it might have failed and pointed back to the previous owner.
Currently we are using ver 9.0.4 (Server & Desktop).
Correct because nothing was changed on the server. Have the new owner download the workbook, update the credentials, and publish the workbook back on to the Server, making sure they DO overwrite the existing report and they DO embed the password during the publishing process.
Please let us know if this works or not.
Sure, we ll educate users on this.
As a Tableau Server Admin, I'd prefer that there was some option here.
I frequently need to go in and update users workbooks.. but would prefer to change the owner back to the original as many users filter by their own workbooks.
I have experienced this as well.
I don't believe it used to work this way.