KNOWLEDGE BASE

Error "['TRY_CONVERT' is not a recognized built-in function name] Refreshing Extracts After Upgrade


Published: 10 Aug 2021
Last Modified Date: 12 Aug 2021

Issue

After upgrading Tableau Desktop or Tableau Server, Microsoft SQL Server extract refreshes fail with the following error: ['TRY_CONVERT' is not a recognized built-in function name]

Environment

  • Tableau Server 2021.2 or later
  • Tableau Desktop 2021.2 or later
  • Microsoft SQL Server

Resolution

The TRY_CONVERT function is unavailable when the Microsoft SQL Server database compatibility level is less than 2012.

Work with your Microsoft SQL Server administrator to change the compatibility level to 110 (SQL 2012) or 120 (SQL 2014) in order to use TRY_CONVERT.  

Additional Information

Newer versions of Tableau use the TRY_CONVERT function in some scenarios to avoid potential issues with ISNUMERIC varchar to float conversion errors for SQL Server.
Did this article resolve the issue?