4 Replies Latest reply on Jul 22, 2017 8:29 AM by Arup Chakraborty

    How to see the data source from a twbx file

    Arup Chakraborty

      Hi Experts,

       

      This may be a common issue ans mentioned somewhere but as a pretty new guy in tableau, I am getting confused.

      I have download a .TWBX file from tableau public 10.0 and trying to open the same in Tableau desktop 10.3. The file opens and running fine. However, I am not be able to see the data source tab or underlying data structure of the twbx file.

      I am able to see that this is using "Sample- Superstore Sales" as a data source and there is also an extract from a live (from the double cylinder sign).

      But while I am clicking the data source tab, an window is opening and asking to select data source file.

      How can I see the data structure through data source tab?

       

      Thanks in advance.

        • 1. Re: How to see the data source from a twbx file
          Matt Lutton

          Hi Arup,

           

          This is because the data has been "Extracted", so Tableau is asking for the original file to show you the structure.

           

          Your best bet is to simply right click on the extracted data source in your workbook and choose "View Data" -- you can then export to Excel or any other data tool of your preference.  This is probably the easiest way to see the structure of the data in the Extract file.

           

          Cheers,

          • 2. Re: How to see the data source from a twbx file
            Arup Chakraborty

            Hi Matt,

             

            Highly appreciating your response and help. I got your point and its really helping.

             

            However, I have a small question. In the said method, I will not be able to see how many tables has been used and type of join. Is there any way to know this?

            • 3. Re: How to see the data source from a twbx file
              Raj CH

              Hi Arup,

               

              This is a standard prompt by tableau when you click on "Edit Data Source" or on "Data Source" for a .twbx file.

              Probably because of the reason when you click on edit data source tableau will try to trace the actual source file location and as it will be not reachable (as user is different), tableau will ask you to redefine the path.

               

              Solution:

              Step 1 : Navigate to Data menu > Data Source (generally last option in the drop down) > export data to csv.

              (If you only want to view data this is enough, if you need to see the joins then continue with below )

              Step 2  : Convert above exported csv into the file type of the original one (you can identify this based on when you click on data source, check what type of file it is asking)
              Step 3 : Click on the Data Source navigate to the above saved file and you can now see the Data Pane window

               

              Regards,

              Nagraj Chepuri.

              • 4. Re: How to see the data source from a twbx file
                Arup Chakraborty

                Dear Nagraj,

                 

                Thanks for the nice answer. Its really helpful.

                 

                However, the biggest problem I am facing is to see the join types or number of tables which has been used to create the dataset. Unfortunately probably Tableau has not given that facility to us.