I have an urgent situation where I have a .twb file with a connection to a Tableau data source (MS Sql connection). I also have an extract of the same data source stored off as a .tde file. I have several complex calculated fields as well, across several sheets.

The data source was updated on Tableau Server and now when I open the .twb file the data source connection automatically updates and marks all of my calculated fields, which were quite time consuming to create, as "invalid column names." The calculated fields are are labeled as not existing in the database and there is no way to view the underlying logic. Duplicating the calculated fields creates a new calculated fields with references to invalid calculations, e.g., [calculation__########]

Since I only have a .twb file I can not recover the original calculated field logic. I have read that metadata is stored in .tde files.

My question is:

Given a .twb with a live ms sql server data source connection, where the data source is automatically replaced, what ways exist to recover the original calculated fields and use them against the new data source so that sheets, dashboards can display as expected. I'm pretty upset that replacing data sources would cause this behavior.

I don't believe I can follow the suggestions given in here because the data source is automatically updated...