title: issue while publishing data source sql server using parameterized stored procedure with live connection to tableau server
body: <p>I have a parameterized stored procedure which takes a value from tableau parameter list, runs on the DB (sql server) and returns the data for views. It is a live connection. It works well on the desktop but when we publish it to the tableau server the view doesn't show . It keeps rendering and nothing shows us. Any suggestions on how to resolve it ?
  I have a stored procedure as follow:</p>
  
  <pre><code>create procedure [] { @ID int } 
  as 
  begin 
     set nocount on;
     select col1, col2, col3 from Table1 where col3 = @ID
  End 
  </code></pre>
  
  <p>The ID is input as a parameter from Tableau Now when i use this in Tableau Desktop with a live connection to SQL server it works fine. However when i publish it to Tableau server the view keeps rendering continuously. Why does that happen ? </p>