Unable to Pass Parameters to Stored Procedures

Published: 14 Jan 2014
Last Modified Date: 02 Jun 2016


It's not possible to pass parameters dynamically to Microsoft SQL Server stored procedures in Tableau Desktop or Tableau Server.


Tableau Desktop


When you want to dynamically pass input parameters to a Microsoft SQL Server stored procedure in Tableau Desktop, do not connect to a stored procedure. Instead, follow the steps in Connecting to a Custom SQL Query to do the following:
  1. Connect to a custom SQL query. 
  2. Use parameters in the custom SQL query to replace a constant value with a dynamic value.
  3. Update the parameter in the workbook to modify the connection.


Tableau Desktop does not support dynamically passing parameters to stored procedures.
Did this article resolve the issue?