3 Replies Latest reply on Feb 13, 2014 12:58 PM by Lynn Edwards

    Tableau Extract being deleted - bug

    Lynn Edwards

      Using tableau 8.1

       

      I have a workbook I create a connect to a sql server table, create hierarchies, folders, calculations and the like using the master update workbook.  I save this workbook separately and use it to update my master extracts weekly.

       

      My master extracts I use to create content/scorecards/analysis.

       

      I am not sure the exact order of what causes the new file to start deleting the master extract.

      It may be from updating or adding a new field to the master extract.

      The solution to fixing it seems to be deleting the extract from the workbook, telling it to connect directly to the extract, saving it as a workbook and then redoing the 'mini extract' at a workbook level.

       

      Has anyone seen this behavior before?

        • 2. Re: Tableau Extract being deleted - bug
          Sharon Sanford

          I think I also just had the same problem.  I was in the middle of working on my tableau workbook, and I had an exception error come up that it was unable to connect to my extract, which was on my c: drive.  I checked the c: drive and the extract was no longer there.  It somehow got deleted (not by me).  I had to re-extract my data which was also from an SQL server table.

          • 3. Re: Tableau Extract being deleted - bug
            Lynn Edwards

            First - my condolences as this is a difficult issue to deal with, especially if you have large data sources.

             

            The cause appears to be around the metadata.  If you don't have any folders or hierarchies built out, I don't believe it will happen.  My feeling is it is around folders since the issue didn't occur prior to 8.1. 

             

            You create an extract with folders/metadata and then use this extract in a new workbook.  Once you save with this new workbook it will delete the extract.

             

            Either way, once it happens on your workbook, it will continue to delete the extract every time you save.

             

            The solution to this is to open your new workbook, do a full refresh/extract and then from the file menu export packaged workbook.  Do NOT save it (it will delete again of course).  Close the workbook, open your newly minted exported workbook and you are good to go.  From there you can save as tableau workbook again if you want and continue along your way and save as normal.  The process of exporting it seems to bring over the folder/file/metadata structure.

             

            I've reproduced this issue from scratch using the sales example data set. I am awesome - I can make extracts delete on the fly!

            1 of 1 people found this helpful