KNOWLEDGE BASE

Unable to Pass Parameters to Stored Procedures


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

Issue

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

Environment

Tableau Desktop
 

Resolution

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.

Cause

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