KNOWLEDGE BASE

Tableau Parameter not available to select for Stored Procedure Parameter


Published: 04 Aug 2015
Last Modified Date: 07 Mar 2017

Issue

When connecting to a stored procedure, the customer is prompted with two options for entering a value:
1 - Enter a Value
2 - Create a new Parameter
A parameter created previously in the workbook is not available.  Why?

Environment

  • Tableau Professional 9.0.1
  • MS SQL Server

Resolution

Change the Data type of the Tableau Parameter to match the data type for the Stored Procedure Parameter.

     Remember:  'Date' data type != 'Date & Time' data type

Cause

The Data type of the Tableau Parameter must match the data type for the stored procedure parameter for it to appear in the drop-down list of available values to pass to the Stored Procedure.
Did this article resolve the issue?