Are you able to download that Report and change the parameter directly within the latter?
Re-host the Report on Server, then, and you should be all good... but something tells me your issue is more complex. Could you please detail it a bit more?
Lénaïc RIÉDINGER, Global Community Engineer Tableau
If you see a Helpful or Correct response, please mark it thanks to the buttons below the targeted post!
Mark, I would rather suggest you to extract whole data source rather than sending request to your database for every query.
to do this, extract all data from sql views and add context filters or tableau parameters to process your request
I've learned a little bit more about stored procs and Tableau since I posted this. As far as I know Tableau will only requery the database if the parameter is changed. So any other filter actions will not cause a requery. In this case I don't really see the difference in using Live vs. Extract for a stored proc. I think my logic was to use an extract to avoid re-processing the data with different filter selections or whatever else.
In my case there is only one parameter that can be changed. But on Server with a live connection to the stored proc, I change the parameter and the view hangs up. Eventually erroring out with an error I apparently didn't document. It takes about 5 minutes to refresh on Desktop and works fine. If instead of live I choose extract, I change the parameter on Server and nothing happens.
I may end up adopting the suggestion from Parul above and extract a large amount of data at once and give the user the option to filter. However, I'm not sure that I can do that unless I extract the entire data set which is too costly.
Either way, I still would like to know how to run an extracted stored procedure on Tableau Server. Change the parameter and then what is the next step?
extract main dashboard data source (*for performance) keep the rest as how you want.