KNOWLEDGE BASE

Percentile Function Is Not Available For Live Connection To Published Data Source


Published: 03 Feb 2020
Last Modified Date: 04 Feb 2020

Issue

Tableau Server host published data sources. Many scenarios, the published data sources need be connected to, and the workbooks need utilize the PERCENTILE function.
 

Environment

  • Tableau Desktop

Resolution

As workaround, rather than use live connection to Tableau Server, embed the extract to workbook, then publish the workbook with extract embedded to Tableau Server.

Cause

PERCENTILE function doesn't support live connection to Tableau Server.

Additional Information

Currently, the PERCENTILE function is available for the following data sources.

  • Non-legacy Microsoft Excel and Text File connections.

  • Extracts and extract-only data source types (for example, Google Analytics, OData, or Salesforce).

  • Sybase IQ 15.1 and later data sources.

  • Oracle 10 and later data sources.

  • Cloudera Hive and Hortonworks Hadoop Hive data sources.

  • EXASOL 4.2 and later data sources.
     

To voice your support on our Community Forums, please add your vote to https://community.tableau.com/ideas/10841
 

Did this article resolve the issue?