Tableau – Where is the path to my extract!?!

Suppose you create an extract in your desktop version of Tableau and everything is running great. Then one of your peers casually asks "how big is that .tde file anyway?" You quickly check file explorer and discover the extract is not in the default location (What is the default path?). It seems like there should be some way to see this in Tableau but I sure couldn't figure it out (hit me in the comments if you have the scoop).

So here's how to find out where your Tableau extract is:

  1. Open your .twb file using your favorite text editor (notepad, notepad++, etc.)
  2. Do a search/find for the following xml:
    <extract
  3. Go to the next line which should begin with the tag:
    <connection
  4. Find the attribute
    dbname=

    . The path to your extract file should be immediately after.

Oh yeah! You're a rockstar!

By Phil Steffek

Phil Steffek is a professional sumo wrestler who is hoping to represent the U.S. in the next Olympics. During the off season Phil is a Data Architect working on transactional databases, data warehouse implementations, and all aspects of business intelligence. Also, Phil is not really a sumo wrestler. You can get to know a bit more about my non-sumo doings by checking out my LinkedIn Page

Leave a comment

Your email address will not be published. Required fields are marked *