Hyper Support Resources

All Support information about Hyper conversion and compatibility.

Overview

Hyper is Tableau's in-memory Data Engine technology optimized for fast data ingest and analytical query processing on large or complex data sets. The introduction of Hyper results in a number of changes related to extracts. Beginning in Tableau 10.5, new extracts use the .hyper file format instead of the .tde file format.

The sections below explain what actions will cause a .tde extract to upgrade to a .hyper extract, common issues you may experience, and important compatibility considerations that will arise after upgrading your Tableau product (for example, Tableau Desktop, Tableau Online and Tableau Server are not upgraded simultaneously). Please review this content as part of your upgrade plan.

To jump to a specific product section, click one of the options below:

Tableau Desktop File Conversion for .hyper Extracts

After an upgrade of Tableau Desktop, Tableau Server, or Tableau Online, you might experience new issues or behaviors with your extracts and/or workbooks. Performing specific actions will change the existing .tde extract to the new .hyper extract format.

When updating, publishing or sharing your work with others, there are a few considerations to take into account:

  • Once an extract has been upgraded to the new .hyper extract format, the change is not reversible. This means that the upgraded extract cannot be converted back to a .tde extract, and that the upgraded extract cannot be opened in a version of Tableau Desktop earlier than 10.5.
  • Upgraded extracts are not backward compatible. We recommend that Tableau Server and all the copies of Tableau Desktop in your organization be on the same version and be upgraded to 10.5 (or later) on the same schedule.
  • For more information about compatibility issues, see Desktop and Server Compatibility

    The below table shows which actions trigger the conversion of the .tde format to the new .hyper format. A blue checkmark indicates that the extract will be converted to .hyper format.


      Tableau Desktop
    10.4 and earlier 10.5 and later
    Full Extract Refresh
    Append Data to an Extract
    Manual Upgrade of the Extract

Extract compatibility scenarios - Tableau Desktop and Tableau Reader

See the below table for more information about how extracts are compatible between Tableau Desktop and Tableau Reader.

  Workbook and extract are created in Tableau Desktop 10.4 and earlier Workbook created in Tableau Desktop 10.5 or later using a 10.4 Extract Workbook and extract are created in Tableau Desktop 10.5 and later
Open workbook using Tableau Reader and Tableau Desktop 10.4 and earlier You can open this workbook. You will not be able to interact with the workbook or the extract. See this Knowledge Base article for details. You will not be able to interact with the workbook or the extract. See this Knowledge Base article for details.
Open workbook using Tableau Reader and Tableau Desktop 10.5 and later You can open this workbook. Please note that this is the expected versioning behavior and that extracts do not affect this scenario. You can open this workbook. Please note that this is the expected versioning behavior and that extracts do not affect this scenario. You can open this workbook. Please note that this is the expected versioning behavior and that extracts do not affect this scenario.

Tableau Online - File Conversion for .hyper Extracts

After Tableau Online upgrades, your users might notice or report that their .tde extracts have been changed to a new .hyper format; or they might receive error messages that mention the new .hyper extract format. Extract files are converted by the improved data engine, which will help Tableau users create and refresh larger extracts faster.

To understand when extracts are upgraded from .tde to the new .hyper format, see the table below. A blue checkmark indicates that the extract will be upgraded to .hyper format. More details can be found in What causes an extract upgrade? in Tableau Help.

For more information about Tableau Desktop file conversion considerations, see the Tableau Desktop Upgrade page.

  Tableau Bridge Tableau Data Extract Command-Line Utility Tableau Online
10.4 and earlier 10.5 and later 10.4 and earlier 10.5 and later
Full Extract Refresh
Incremental Extract Refresh
Append Data to an Extract


Understanding the above behaviors

What does it mean exactly? See the below specific points to understand what is occurring and what you can advise your Tableau users to do:

  • All refreshes ran by Tableau Online will upgrade your .tde extract to .hyper format.
  • Once an extract has been upgraded to the new .hyper extract format, the change is not reversible. This means that the upgraded extract cannot be converted back to a .tde extract and that upgraded extracts cannot be read by the Tableau 10.4 (earlier) data
    engine.
  • After performing full refresh of a data source using a 10.4 (or earlier) client (such as Tableau Bridge, Tableau Data Extract Command-Line Utility, APIs, etc.): you will be able to perform the refresh and the extract will remain in a
    .tde format. Additionally, you can open and connect to the published data sources using Tableau Desktop 10.4 (and earlier versions).
  • After performing an incremental refresh of a data source using Tableau Bridge 10.4 (or earlier): you will be able to perform the refresh and the extract will be saved in .hyper format. However you will not be able to open this refreshed
    data source using Tableau Desktop 10.4 and earlier versions (whether it has been incrementally or fully refreshed) and you will be asked to locate and regenerate the extract after downloading and opening the data source using Tableau Desktop 10.4 (and
    earlier versions). Redirect your users to “What to expect after an extract upgrade” for steps to recreate the extract.
  • After performing an incremental refresh of a data source using a 10.4 (or earlier) client (such as the Tableau Data Extract Command-Line Utility, APIs, etc.): you will be able to perform the refresh and the extract will be saved in .hyper
    format. Please note that you will be asked to locate and regenerate the extract after downloading and opening the data source using Tableau Desktop 10.4 (and earlier versions). Redirect your users to “What to expect after an extract upgrade” for steps to recreate the extract.


Finding out when an extract has been converted

To see specifically which extracts will be affected, you can use the admin view and filter by job type, for more information see Background Tasks for Extracts.

Filtering the Tasks to ‘TdeRefreshExtract’ and ‘TdeIncrementalExtract’ will identify all extracts that are currently in .tde format which will be upgraded to .hyper format.

Tableau Online Extract compatibility scenarios

If your Tableau Online users report that they are unable to perform specific actions when they are interacting with extracts, they might have run into an extract compatibility issue.

The table below shows examples of scenarios seen from a user perspective and describes what happens in the background of Tableau Online, when specific actions involving extracts are performed.

Please note that the below behaviors for workbooks are the same for published data sources.


  Workbook and extract are created in Tableau Desktop 10.4 and earlier Workbook created in Tableau Desktop 10.5 or later using a 10.4 Extract Workbook and extract are created in Tableau Desktop 10.5 and later
As a Tableau Online and Desktop user, you attempt to publish your workbook or extract to Tableau Online
 
  • You are able to publish this workbook or extract
  • Extract remains in a .tde format
  • You are able to publish this workbook or extract
  • Extract remains in .tde format
  • You are able to publish this workbook or extract
  • Extract is saved in .hyper format

  Workbook and extract are created in Tableau Desktop 10.4 and earlier Workbook created in Tableau Desktop 10.5 or later using a 10.4 Extract Workbook and extract are created in Tableau Desktop 10.5 and later
As a Tableau Online and Desktop user, you try to Web-edit/ Save your workbook to Tableau Online

(after publishing to Tableau Online)
 

No refresh or append in Tableau Online

  • You are able to web-edit this workbook
  • You will no longer be able to download it and open it in Tableau Desktop 10.4 or earlier versions. However you will be able to export this workbook as an older version.
  • Extract remains in .tde format
  • You are able to web-edit this workbook
  • Extract remains in .tde format
  • You are able to web-edit this workbook
  • Extract remains in .hyper format
 

Refresh or append the extract in Tableau Online

  • You are able to web-edit this workbook
  • When the next refresh occurs, the extract is saved in .hyper format
  • You are able to web-edit this workbook
  • Extract is saved in .hyper format
  • You are able to web-edit this workbook
  • Extract remains in .hyper format

  Workbook and extract are created in Tableau Desktop 10.4 and earlier Workbook created in Tableau Desktop 10.5 or later using a 10.4 Extract Workbook and extract are created in Tableau Desktop 10.5 and later
As a Tableau Online and Desktop user, you attempt to download and open the workbook and the extract
 

Using Tableau Desktop 10.4 (and earlier)

  • You are able to download and share this workbook. After web-editing the workbook, you will no longer be able to download it and open it in Tableau Desktop 10.4 or earlier versions.
  • If you do not edit the workbook but you perform a refresh/append, you may be asked to locate and regenerate the extract after downloading and opening the workbook using Tableau Desktop 10.4. See “What to expect after an extract upgrade” for steps to recreate the extract.
  • You can export this workbook as an older version.
You cannot interact with the workbook or the extract. See this Knowledge Base article for details. You cannot interact with the workbook or the extract. See this Knowledge Base article for details.
 

Using Tableau Desktop 10.5 and later

  • You can download and open this workbook and extract.
  • If you encounter difficulties editing or downloading the workbook using an older version of Tableau Desktop, please refer to the following Knowledge base article.
  • You can download and open this workbook and extract.
  • If you encounter difficulties editing or downloading the workbook using an older version of Tableau Desktop, please refer to the following Knowledge base article.
  • You can download and open this workbook and extract.
  • If you encounter difficulties editing or downloading the workbook using an older version of Tableau Desktop, please refer to the following Knowledge base article.

  Workbook and extract are created in Tableau Desktop 10.4 and earlier Workbook created in Tableau Desktop 10.5 or later using a 10.4 Extract Workbook and extract are created in Tableau Desktop 10.5 and later
As a Tableau Online user, you use the "Export as Version..." in Tableau Desktop and open the workbook in the corresponding Tableau version (or higher)
  If the workbook is using a .tde extract, you can export and open this workbook and extract in the corresponding Tableau version (or higher). If the workbook is using a .tde extract, you can export and open this workbook and extract in the corresponding Tableau version (or higher). Since this data source is using a .hyper format extract, this action cannot be performed. The option will be grayed out. See this Knowledge Base article for details.**
 

**When using the "Download as Older Version" option in Tableau Online, you can download an earlier version of this workbook (such workbook can be opened by Tableau Desktop 10.4 and earlier). However please note that if a .hyper extract is used, it will be included in the packaged workbook file, and such file cannot be read by older versions of Tableau Desktop.

Attempting any action in Tableau Desktop 10.4 and earlier versions with an extract that was created in Tableau Desktop 10.5 or later will result in an error message. Please view this Knowledge Base article for details.

Tableau Server File Conversion for .hyper Extracts

We recommend that Tableau Server and all the Tableau Desktops in your organization be on the same version and be upgraded to 10.5 (or a later version) on the same schedule.

After upgrading Tableau Server, your users might notice or report that their .tde extracts have been changed to a new .hyper format; or they might receive error messages that mention this new .hyper extract format. This extract file conversion is a part of the improved data engine, it will help Tableau users create and refresh larger extracts faster.

For more information about Tableau Desktop file conversion considerations, see the Tableau Desktop Upgrade page.

To understand when extracts are upgraded from .tde to the new .hyper format, see the table below. A blue checkmark indicates that the extract will be converted to .hyper format. More details can be found in What causes an extract upgrade? in Tableau Help.


Tabcmd Tableau Data Extract Command-Line Utility
Full Extract Refresh
Incremental Extract Refresh
Append Data to an Extract


Tableau Server Extract compatibility scenarios

If your Tableau Server users report that they are unable to perform specific actions when they are interacting with extracts; they might run into an extract compatibility issue.

The table below will give you examples of scenarios about what occurs from a user perspective and in the background of Tableau Server when performing specific actions.

  Workbook and extract are created in Tableau Desktop 10.4 and earlier Workbook created in Tableau Desktop 10.5 or later using a 10.4 Extract Workbook and extract are created in Tableau Desktop 10.5 and later
As a Tableau Server and/or Desktop user, you attempt to publish your workbook or extract
 

To Tableau Server 10.4 and earlier

  • You are able to publish this workbook or extract
  • The extract remains in a .tde format
  • You will receive an error, please view this Knowledge Base article for details.
  • In Tableau Server 10.4 and earlier, it is compatible with all corresponding Tableau Server versions.
You will receive an error, please view this Knowledge Base article for details.
 

To Tableau Server 10.5 and later

  • You are able to publish this workbook or extract
  • The extract remains in a .tde format
  • You are able to publish this workbook or extract
  • The extract remains in a .tde format
  • You are able to publish this workbook or extract
  • The extract is saved in .hyper format

  Workbook and extract are created in Tableau Desktop 10.4 and earlier Workbook created in Tableau Desktop 10.5 or later using a 10.4 Extract Workbook and extract are created in Tableau Desktop 10.5 and later
As a Tableau Server and/or Desktop user, you try to web-edit/save to Tableau Server

(after publishing it to Tableau Server)
 

No refresh or append in Tableau Server

  • You are able to web-edit this workbook.
  • In all Tableau Server versions, the extract remains in a .tde format.
  • You are able to web-edit this workbook.
  • In Tableau Server 10.5 and later, the extract remains in a .tde format
  • You are able to web-edit this workbook.
  • The extract is saved in .hyper format
 

Refresh or append the extract in Tableau Server

  • You are able to web-edit this workbook.
  • In Tableau Server 10.4 and earlier, the extract remains in a .tde format.
  • In Tableau Server 10.5 and later, after editing the workbook or appending the extract, the extract is converted to the new .hyper format.
  • You are able to web-edit this workbook.
  • In Tableau Server 10.5 and later, the extract changes to the new .hyper format.
  • You are able to web-edit this workbook.
  • The extract is saved in .hyper format

  Workbook and extract are created in Tableau Desktop 10.4 and earlier Workbook created in Tableau Desktop 10.5 or later using a 10.4 Extract Workbook and extract are created in Tableau Desktop 10.5 and later
As a Tableau Server and Desktop user, you attempt to Download and open the workbook and the extract
 

Using Tableau Desktop 10.4 (and earlier)

  • You are able to download and open this workbook.
  • In Tableau Server 10.4 and earlier, it is compatible with all corresponding Tableau Server versions.
  • In Tableau Server 10.5 and later, you can open workbook but you will be unable to use the extract. See this target="_blank">Knowledge Base article for details
In all Tableau Server versions, you will receive an error message, see this Knowledge Base article for details. In all Tableau Server versions, you will receive an error, see this Knowledge Base article for details.
 

Using Tableau Desktop 10.5 and later

You are able to download and open this workbook. Since the extract was published as a .hyper extract, you are able to download and open this workbook from Tableau Server 10.5 and later versions. Since the extract was published as a .hyper extract, you are able to download and open this workbook from Tableau Server 10.5.

  Workbook and extract are created in Tableau Desktop 10.4 and earlier Workbook created in Tableau Desktop 10.5 using a 10.4 Extract Workbook and extract are created in Tableau Desktop 10.5 and later
As a Tableau Server user, you use the "Export as Version..." in Tableau Desktop and open the workbook in the corresponding Tableau version (or higher)
 
  • If the workbook is using a .tde extract, you can export and open this workbook and extract in the corresponding Tableau version (or higher).
  • After the workbook was edited and saved in Tableau Server 10.5 (or later), you can download this workbook and extract and open it in the corresponding tableau version (or higher).
If the workbook is using a .tde extract, you can export and open this workbook and extract in the corresponding Tableau version (or higher). Since this data source is using a .hyper format extract you cannot export the workbook to an older version of Tableau. See this Knowledge Base article for details.
 

Attempting any action in Tableau Desktop 10.4 and earlier versions with an extract that was created in Tableau Desktop 10.5 or later will result in an error message. Please view this Knowledge Base article for details.

Troubleshooting Extracts with Tableau Server

If your users experience or report any of the following behaviors while performing an extract task, they may be running into an incompatibility scenario. Please redirect them to the following Knowledge Base articles to resolve the error(s).

  • "This workbook uses a .hyper extract and is not compatible with this version of Tableau. Open this workbook in Tableau 10.5 or later."
  • "Export as version" grayed out for workbooks with .hyper extract.
  • "The document cannot be downgraded, because it contains direct connections to .hyper extracts."
  • The View changes after upgrading (becomes blank, fewer marks in the view, more null values when you inspect the summary data, or the view itself has a different shape).
  • For more information about updating extract data sources that are published to Tableau Server, see Update Server Data Sources That Are Using Extracts in Tableau Help.