Perform the following steps in Tableau Desktop:
- Check the Use Extract option.
- Save the workbook in the .twbx file format.
Thanks Tharashasank but that does not work.
First, the option Use Extract does not show as an option for Tableau Published Extracts. Second, if you were to make the file a local copy extract it still dissociated from the originating connections(either SQL, CSV, etc) then the Use Extract option still will not work. Thirdly, this is not a workbook related problem, this is a data source issue.
Let me know if you need more clarity.
Here is an update for those who stumble on this post in the future.
Sadly Tableau Support was unable to help/fix the issue. They also mentioned this is a known issue with a tentative fix.
From Tableau Support:
Investigating the issue internally, this looks to be a known issue currently under investigation that has a tentative fix in the next maintenance release but I will confirm that this matches the behavior seen via the provided Tableau Server Logs.
The three solutions they offered:
Reconnect the .tde file through Tableau Desktop. This did work.
Reassign the LUID so that it points to the right folder. This did not work.
Rebuild by hand and republish data source. This was the unfortunate resolution we had to go with. Luckily we stumbled upon a blog post about editing .tdsx files which has the XML information for a data source. We documented the process of rebuilding data sources if anyone is interested.
Here is a link to the blog post that gave us the idea to edit the xml.