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

Published: 03 Feb 2020
Last Modified Date: 08 Jul 2022


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


  • Tableau Desktop


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.


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

Did this article resolve the issue?