I'm calling a parametric stored procedure in Tableau which brings in a result based on supplied emailId. I see the stored procedure works file and returns results as expected for just one value and when I type or change emailID tableau does not return any results even though there are values in database and stored procedure works as expected in SQL server. It looks like Tableau is working for just one value and not for others. I have over a million ID's in database as such I cannot hard code values as suggested in few forums.
I tried to execute the procedure without passing a value but it shows error as attached in the snip.
we can select one value in Parameter and try using live connection with parameter.