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

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