Tableau 2020.3
Write to external databases in Tableau Prep, grant licence on sign-in and deeper
integration with SAPScale your analytics and governance further
Write to external databases in Tableau Prep
Store your prepped data from Prep Builder in a central location that can be used throughout your organisation. Govern and scale the investments you've made in your databases by providing a visual and direct field mapping experience to ensure your prepped data ends up where it should be.
Learn more![grant license on sign in new in 2020.3](/sites/default/files/grant-role-at-sign-in_cropped_0.png)
Grant licence on sign-in
We're making it easier to optimise your organisation's seat investment, extending the value of Tableau to more users. Site admins can now designate members – specific individuals, teams and departments, or even your entire organisation – to be automatically granted a site role (Viewer, Explorer, Creator) upon their first time logging in to their Tableau Cloud or Tableau Server account. Deploy Tableau at scale without having to manually respond to licence requests, and quickly scale up when needed.
![Tableau SAP certification new in 2020.3](/sites/default/files/tableau-sap-cert.png)
SAP HANA connector improvements & new SAP certifications
For our SAP HANA connector, users now have the ability to connect to table functions (stored procedures that return a table). We have also achieved official SAP Certification (HANA-BI-SQL 2.0) for integration with SAP HANA on Tableau Desktop, Prep, Server and Online. Read our new Tableau and S/4HANA analytics white paper for guidance and best practices around S/4HANA integration, and how to optimise the experience of using Tableau and S/4HANA together for analytics.
Tableau 2020.3 feature overview
Tune in for an overview of all the new features included in this release.
Watch nowAll features
Tableau Mobile for Workspace ONE (iOS)
Tableau Mobile for Workspace ONE is an update to the existing app that provides a quick and secure way to view, analyse and leverage the data in your organisation. The new app, compatible with iOS13, includes a newer design that is faster and more intuitive, an improved search and browsing experience consistent with Tableau Server and Tableau Online, as well as enhanced offline capabilities that are quick to load and offer richness and interactivity for visualisations.
Support for Google BigQuery NUMERIC types
Take advantage of using Google BigQuery's NUMERIC data type without having to use CustomSQL. Instead, convert your NUMERIC type to DOUBLE.
![](/sites/default/files/sankey-showmemore.png)
Dashboard extension images
When you generate a .png or .pdf of a dashboard that you are viewing in Tableau Desktop, it will now render the Extension zone's image.
![](/sites/default/files/relationships_2020-3.gif)
Relationship improvements
Create relationships between tables in your data source with more flexibility. You can now relate tables based on custom calculated fields, like concatenated fields or date truncation, and inequality operators. Additionally, we've improved the drag-and-drop experience in the data model.
![](/sites/default/files/tag_external_assets_big1.jpg)
Tag external assets in Tableau Catalog
Make it even easier to find the right data by tagging external assets, including databases, tables and columns.
![](/sites/default/files/embedded_files_big.jpg)
Include embedded files in external assets list
See every asset in your environment via external assets, including files and tables that are embedded in workbooks. This provides a holistic view of what data users are leveraging outside of published data or content.
![](/sites/default/files/data-quality-warnings_desktop.png)
Data quality warnings in Tableau Desktop
Keep users informed of data quality warnings while they're performing their analysis in Tableau Desktop. With a quick indicator on the data source, users know get the information they need about the state of the data.
Connect to Presto in web authoring
Connect to and analyse your Presto data from the web authoring experience of Tableau Server or Tableau Online.
![](/sites/default/files/schemaviewersearch_0.gif)
Search improvements in Data pane
Use filters in the data pane to refine your search and find the right field you need for analysis. Search and filter based on field name, type or comments.
![](/sites/default/files/inoperator_1600x800.png)
IN operator for calculations
Use the IN operator in calculations to test whether a specified value matches any value in a list of comma-separated values, a set, or combined fields like City/Region combinations. The IN operator supports string, numeric, date and boolean data types.
![](/sites/default/files/tag-stale-content_0.png)
Tag stale content
You can now tag stale content directly from the stale content admin view for easy follow up with content owners.
![](/sites/default/files/spatial-file-union.png)
Spatial file union
Analysing spatial data just got easier – you can now union two or more tables that contain spatial field types in Tableau. With the spatial file union, combining unique geographies within the same administrative level, or working with geographic events from different periods of time, are both made simple. For example, you can now easily union and explore multiple tables with wildfire boundaries from 2017, 2018 and 2019, without having to leave Tableau.
Query marks selected via row or header
For the marks selection event, when a user clicks on a column or row header, the marks in that column or row are selected and will now return correctly when querying the selected marks in the API.
NullOptions in applyRangeFilterAsync
When applying a quantitative filter to a field or a date, you can pass fields into the applyRangeFilterAsync method to control advanced filtering options. One of the options is NullOptions and you can now indicate what to do with null values when applying the filter.
![](/sites/default/files/subscription-run-on-extract-refresh.png)
Subscription run on extract refresh
You can now set a subscription email to run after the underlying extract is refreshed, making it easy to get the latest data out as soon as it's available.Tableau Server installation pre-check
To ensure a smooth installation and upgrade experience, Tableau Server now automatically performs a set of checks as you start the initialisation/upgrade process. These checks are designed to detect common errors and issues (around permissions, credentials, base ports) that can arise during upgrade and install. You can also perform this check at any time with the TSM command. Today, this capability is for Windows, but we are working to bring it to Linux soon.
![](/sites/default/files/explain-data_bikes-temperature_gif_small_2_0_0_0.gif)
Explain Data improvements
The underlying model for Explain Data continues to get refined to handle more cases, improve explanation scoring, and support relationships, Tableau's new data modelling enhancements.
![](/sites/default/files/ad_suggested_questions.jpg)
Ask Data improvements
Make your data even more approachable with new improvements to Ask Data. Modify the default query suggestions with colloquial language that is easier for people across your organisation to understand. Additionally, you can now use absolute date filters and access onboarding and curation resources directly from the product.
![](/sites/default/files/pngscreen3.png)
Predictive modelling functions
New prediction functions go beyond the existing trendline analytical function to build a model that understands how your data is distributed around a best-fit line. MODEL_QUANTILE is a table calc that returns a target value at a specified percentile, based on other predictors. MODEL_PERCENTILE is a table calc that returns the probability of the expected value being less than or equal to the observed mark, based on other predictors.
![](/sites/default/files/background-maps-menu-updates_0.png)
Background maps improvements
The ability to add third-party map services, such as WMS Maps or Mapbox Maps, is now available directly in the background maps menu. Enjoy an updated UI to more easily add and manage your external map connections.
Accessible relative date filters
Relative date filters are now fully keyboard- and screen reader-accessible, enabling more relevant and complete analysis.
![](/sites/default/files/web-authoring_data-source-and-viz-filters.png)
Web authoring improvements
Quickly filter to the data you care about with the ability to create, edit or remove data source or viz filters in the browser.
![](/sites/default/files/grant-role-at-sign-in_cropped.png)
Grant role at sign-in
We're making it easier to optimise your organisation's seat investment, extending the value of Tableau to more users. Site admins can now designate members – specific individuals, teams and departments, or even your entire organisation – to be automatically granted a site role (Viewer, Explorer, Creator) upon their first time logging in to their Tableau Online or Tableau Server account. Deploy Tableau at scale without having to manually respond to licence requests, and quickly scale up when needed.
New connectors in the Extension Gallery
Customers looking to connect to data sources beyond Tableau’s native connector list can now find connectors in the Tableau Exchange, built by partners like Qubole, Dremio, Yellowbrick and SQream.
Visit the Tableau Extension GallerySAP HANA connector improvements & new SAP certifications
For our SAP HANA connector, users now have the ability to connect to stored procedure objects as if they were a table. We have also achieved official SAP Certification (HANA-BI-SQL 2.0) for integration with SAP HANA on Tableau Desktop, Prep, Server and Online. Read our new Tableau and S/4HANA analytics white paper for guidance and best practices around S/4HANA integration, and how to optimise the experience of using Tableau and S/4HANA together for analytics.
![](/sites/default/files/write_to_database_cropped.png)
Write to external databases in Tableau Prep
Store your prepped data from Prep Builder in a central location that can be leveraged throughout your organisation. Govern and scale the investments you've made in your databases by providing a visual and direct field mapping experience to ensure your prepped data ends up where it should be.
![](/sites/default/files/group_flow_0.png)
Group Steps
Combine steps together in your flow to help you build a flow that meets your mental model or business rules. With the ability to collapse and expand your groups, you can quickly find and go to the part of your flow that needs to be addressed.
![](/sites/default/files/file_recovery.png)
File Recovery
Don't worry about losing the work you've been doing combining, cleaning, and prepping your data. File recovery will automatically save drafts so you can get back to where you left off even when something unexpected happens.
![](/sites/default/files/customfiscaldate_0.png)
Custom Fiscal Dates
Easily update the start date of your organization's fiscal year to more quickly prep and analyze your data accurately.
![](/sites/default/files/viewrecs_on_mobile.png)
View recommendations on Tableau Mobile
View recommendations are now on Tableau Mobile. Get personalised suggestions that instantly connect you to relevant vizzes on the go. Powered by machine learning, these recommendations leverage users' preferences and surface vizzes that others with similar viewing habits found interesting, and that are popular on your site. With the Home tab, you can find recommendations in a dedicated channel on your Tableau Mobile app.
Set control updates
Context filters can now control the list of values displayed by the set control in a dashboard, allowing end users to select from the most relevant values to power their analysis.
![](/sites/default/files/shared-with-me.png)
New "Shared with me" tab
Quickly access projects, workbooks and dashboards that others have shared with you on Tableau Server or Tableau Online all in place, via the "Shared with Me" tab on the home menu. Customised views are automatically saved separately, so that you can quickly navigate to the personalised view you need.