Upgrade Tableau Prep Builder
What you need to know when upgrading Tableau Prep Builder
Overview
Introduction to Tableau Prep Builder
How to get Tableau Prep Builder
Start using Tableau Prep Builder:
Choosing a version
Tableau Release Navigator
- Understand what version of Tableau is right for your deployment
- Filter and compare Desktop, Server and Prep features by release
- Perform impact analysis and plan change management for an upgrade with data on major new features and product changes delivered between your current and next versions.
- Release Navigator is on Tableau Public – you can also download and customise it for your use cases.
Tableau technical support release pages
- Known issues - What issues are we currently fixing?
- Release notes - What issues have been fixed in each maintenance release?
- Choose a recent maintenance release - Whichever version (e.g. 2020.4, 2021.2) you are upgrading to, Tableau recommends installing the most recent maintenance release available for that version (e.g. the highest final decimal in 2020.4.4) to get the most recent product fixes.
Tableau Blueprint
Plan change management to support and align with your analytics strategy: Tableau Blueprint - Upgrade planning
Compatibility
Tableau Prep Builder is a stand-alone product that works seamlessly with Tableau Desktop, Tableau Server and Tableau Cloud. At any point while working in Tableau Prep Builder, you can create an extract of your data, publish your data source to Tableau Server or Tableau Cloud, or even open Tableau Desktop directly from Tableau Prep Builder to preview your data.
- Tableau Prep Builder works on Windows and Mac. It can create Tableau extracts (.tde and .hyper) and CSV files that can be used in Tableau 10.0 and later versions of Tableau.
- In Tableau Prep Builder, you can connect to many of the same data sources available in Tableau Desktop, Server and Cloud. For a complete list of Tableau-supported data sources, click here.
- With some data sources, you may need to install drivers before connecting to your data. If this is the case, see the Driver download page.
New workspace for faster speed to insight
Tableau Prep Builder uses Tableau’s data connectors, calculation language, and governance structure, making it possible to get you up to speed quickly and ready to collaborate at any point in the analytical process.
The Tableau Prep Builder workspace consists of the connections pane, the changes pane and three coordinated areas designed to help you interact with and explore your data:
- Connections pane: The Connections pane shows the databases and files you are connected to. Add connections to one or more databases and then drag the tables you want to work with into the flow pane.
- Flow pane: As you connect to, clean, shape and combine your data, steps appear in the flow pane. You can hover over the icons at the top of each step to see what changes were made.
- Profile pane: The profile pane in the centre of the workspace shows a summary of each field in your data sample. This is where users can see the shape of the data and quickly find outliers and nulls.
- Changes pane: Tableau Prep Builder keeps track of any changes you make, in the order you make them, so you can always go back and review or edit those changes if needed.
- Data grid: The data grid shows the row-level detail for your data. The values displayed reflect the operations defined in the profile pane. You can filter, keep only and exclude individual field values in this grid, or drag and drop fields to change the display order.
For complete descriptions, including a video, see Workspace in Product help.
Saving and sharing outputs
Defining output
Tableau Prep Builder can save three types of files:
- .tfl files containing a flow
- .tflx files containing a flow and local file-based data sources, such as Excel and text files
- Output files containing the results of running a flow
Output files can be saved in .hyper, .tde and .csv formats, and are defined in the output step. The output files can be opened in Tableau Desktop and published to Tableau Server or Tableau Cloud.
Tableau Desktop
Running the flow on Tableau Desktop results in a Tableau data extract file, either a .tde or .hyper depending your version of Tableau. Either one will be saved in your Tableau repository in the Datasources folder. It can also be output to .csv files if you need to use your prepared data for other tools or processes. Note! Once an extract has been created, whether .tde or .hyper, and a workbook based on it, the same compatibility rules for use with different versions of Tableau apply as in other usage situations. For more information, see Make workbooks compatible between versions.
Tableau Server
To publish your output to Tableau Server, use the Publish menu in Tableau Prep Builder. The Tableau Server REST API must be enabled in order to receive publish requests from Tableau Prep Builder. For more information see REST API requirements.
Tableau Cloud
You can also use Tableau Prep Builder's Publish menu to publish your output to Tableau Cloud as a .hyper extract, .tde extract or .csv file, and provide centralised access to the data you've cleaned, formatted and combined.
Faster updates to Tableau Prep Builder
We’re moving fast and will be launching new features frequently for Tableau Prep Builder, independently of the Tableau Desktop, Tableau Server or Tableau Cloud release cycles. Customers will need to upgrade to the latest version of Tableau Prep Builder to take advantage of new features and product fixes.
This site will post new links at regular intervals to community user scenarios, product information and – not least – tricks of the trade for the latest in fast, fun and efficient data prep.
Additional resources
How can I get Tableau Prep Builder?
Try Tableau Prep Builder first for free!
Review tech specs
Tableau Prep Builder release notes
Get help
Self-service resources
- Tableau Prep Builder product help
- Knowledge Base
- Tableau Blog
- Tableau Community: Tableau Prep Builder
- For the latest support information regarding Tableau's most recent product versions, follow @Tableau Support on Twitter.
Technical support
- Screenshots of the issue and any error messages (expanded)
- Best times to call