12 Replies Latest reply on Jan 16, 2017 7:27 AM by Michael Hesser

    TWBX-file has no data

    Jan Sprink

      Hello,

      I want to create a packaged workbook with an integrated data source that is published on Tableau Server.

      I followed the instructions in Packaged Workbooks, part "Create a .twbx with Tableau Server data sources".

      Means I did the following:

      1. Open my *.twb-file in Tableau Desktop

      2. Create local copy of the *.tde extract in my workbook.

      3. Extract data of the copy

      4. Replace original data source with copy

      5. Close original extract

      6. Save workbook as *.twbx-file

      7. Open the *.twbx-file with Tableau Reader

       

      After opening the *.twbx-file in Tableau Reader, there are all pages of the workbook but there are no data.

      Every page is empty.

      By opening the same *.twbx-file in Tableau Desktop, the whole content is available.

       

      I am using the following environment:

      OS: Windows Server 2012 R2 x64

      Tableau Server: 10.1.1 (10100.16.1103.2343) 64-Bit

      Tableau Desktop: 10.1.3 (10100.16.1223.0056) 64-Bit

      Tableau Reader: 10.1.3 (10100.16.1223.0056) 64-Bit

       

      Anybody have an idea what I could do or what I did wrong?

       

      Regards,

      Jan

        • 1. Re: TWBX-file has no data
          Wim Kegels

          Hi Jan,

           

          Could you perhaps try the following?

           

          Open the workbook from Tableau server in desktop.  Right click the data source, and select "Use Extract".  Then save the workbook as a .twbx and try to open it in reader.

           

           

          Hope this helps!

           

          Kind regards,

          Wim

          • 2. Re: TWBX-file has no data
            Michael Hesser

            Hi Jan; I think you may be making this more complicated than it needs to be, and inadvertently disconnecting your data sources by making copies of extracts.

             

            Please try this:

            • Open your .TWB
            • Save As a .TWBX onto your desktop (or where ever you want to store the TWBX)
            • Try opening with Reader to see and see if the data exists.
            • Alternatively, you can unzip the TWBX to make sure copies of all extracts exists

             

            Let me know if this works for you! --Michael

            • 3. Re: TWBX-file has no data
              Jan Sprink

              Hi Michael,

               

              this way was the first I tried, but unfortunately without success.

              After this manner the *.twbx was very small.

              After extracting the data in Tableau Desktop an creating a new packaged workbook, the *.twbx was greater but also without data in Tableau Reader.

               

              Jan

              • 4. Re: TWBX-file has no data
                Michael Hesser

                Hi Jan;

                What types of files are you trying to link to your .TWBX?

                Are they network files or SQL queries? I'm wondering if you may be trying to make copies of non-exportable files?

                 

                Have you tried this method:

                • Make a local copy of the TWB
                • Confirm that the data being used are EXTRACTS, rather than LIVE. (it will prompt you to save as extracts if they were live previously)
                • Confirm that the TWB is behaving properly after changing sources to extracts
                • If so... save the TWB
                • Reopen TWB and Save As TWBX. (apologies if these are all the steps you've tried above! )

                 

                We'll get this figured out!

                • 5. Re: TWBX-file has no data
                  Jan Sprink

                  Hi Wim,

                  thanks for your fast answer. I tried your way.

                  Unfortunately the result is the same. The View in Tableau Reader is empty.

                  Regards,

                  Jan

                  • 6. Re: TWBX-file has no data
                    Wim Kegels

                    Hi Jan,

                     

                    Strange.  Could you try the following things?

                     

                    • instead of saving as a twbx, try the "Export packaged workbook" option (File menu) - or the other way around.
                    • open your file by dragging it into a Tableau reader window

                     

                    These are longshots, but perhaps it's a bug somewhere.

                     

                    Kind regards,

                    Wim

                    • 7. Re: TWBX-file has no data
                      Jan Sprink

                      Hi Michael,

                       

                      by using the Tableau API, I create a new *.tde-file every night an publish it to the Tableau Server.

                      The workbook uses the published *.tde-file on the Server.

                       

                      I tried your way

                      • Make a local copy of the TWB
                      • Confirm that the data being used are EXTRACTS, rather than LIVE. (it will prompt you to save as extracts if they were live previously)
                      • Confirm that the TWB is behaving properly after changing sources to extracts
                      • If so... save the TWB
                      • Reopen TWB and Save As TWBX. (apologies if these are all the steps you've tried above! ).

                       

                      I still have no success.

                      The connection to the data source is live, but it connects to the local copy of the *.tde-file.

                      Could that be a problem?

                      • 8. Re: TWBX-file has no data
                        Jan Sprink

                        Hi Wim,

                         

                        I trie both

                         

                        • instead of saving as a twbx, try the "Export packaged workbook" option (File menu) - or the other way around.
                        • open your file by dragging it into a Tableau reader window.

                         

                        Unfortunately still without success.

                         

                        Kind regards,

                        Jan

                        • 9. Re: TWBX-file has no data
                          Jan Sprink

                          Additional information:

                          By opening the same *.twbx-file in Tableau Desktop, every content is available and everything seems to be okay.

                          • 10. Re: TWBX-file has no data
                            Wim Kegels

                            Let's try something else:

                             

                            open the twbx in Desktop, save as a different filename, try again in Reader.

                             

                            Good luck!

                             

                            Wim

                            • 11. Re: TWBX-file has no data
                              Jan Sprink

                              Hi Wim,

                               

                              unfortunately no luck with this attempt, too.

                               

                              Jan

                              • 12. Re: TWBX-file has no data
                                Michael Hesser

                                Hi Jan!

                                I don't know much about Tableau Server, and my brain gets kinda fuzzy when you throw around terms like API. But I think you may have hit the nail on the head:

                                I'm guessing your API programming is circumventing Tableau's TWBX structure and trying to order something that's not on the menu.

                                 

                                SO...riddle me this:

                                Are SaleExtract (11.Jan 2017) and SaleExtract (Live) essentially the same data (though saved in different formats) ?

                                 

                                If so, can you REPLACE SaleExtract (Live) with SaleExtract (extract) in your .TWBX?

                                 

                                If that doesn't work, you might want to speak with Tableau Support. Here's a string of what *appears* to be a similar issue (look further down and you'll see people saying Server files are not being saved to TWBX files).

                                Is it possible to download workbook twbx file use tabcmd

                                 

                                Good luck!