Hey Brian -
A couple thoughts on your situation, and then I'll give you your answer :
- Your problem is fairly common - as Tableau usage grows in an organization, there needs to be a way to keep the TDEs under control, or you run into "Excel ****" all over again - Consider Tableau Server for this purpose. All extracts are published to Server (where they can be secured and automatically refreshed), and users connect to the extracts on our Server like any other published data source.
- It's generally unwise to store your TDEs in a public network share unless your users are very regimented. What generally happens is that people start connecting directly to the TDEs on your network over mapped drives and <gasp>, suddenly "Tableau is slow"! . Well Tableau isn't slow, of course - you're now feeding data across your network...Users should be encouraged to ONLY consume TDEs on their local machine - the speed difference is exponential and will keep people happy.
- Consider "embedding" your extracts directly in the workbook by saving your file as a "Packaged Workbook". This way, where the workbook goes, the (embedded) TDE goes - automatically.
And now for your answer, thanks for being patient!
Right-click the data source in your workbook, choose Extract and then Properties:
...you'll see something like this:
Hope this helps!
That's exactly what I was looking for. Thank you! I knew it was something simple, and am now experiencing a "D'oh moment".
We actually do keep our .tde files away from end-users by embedding data into the packaged workbook. We have several people creating a steady stream of reports. Most copy files from the LAN down to their local drive, make any necessary changes, then copy them back up to the LAN. Sometimes they forget to point the new package back to the proper data source
I have a home-brew (AutoIt) application that runs daily and does a batch update on all the packages for our end users, and of course, it will fail if a package tries to find a data source on someone's laptop who is not around. :-) We're quite new to Tableau, and experiencing growing pains.
Thanks again for the quick answer!