My client plan to go with sql server stored procedure parameter approach.
They don't go with live connection and plan to go with extract.
we have lot of parameters and need to select via parameter in tableau.
I searched and doing extract refresh get some issue with parameters.
I plan to do with sp without parameter approach.
Is there any issue while doing extract refresh in tableau.
I hope someone will help.
I found an approach.
Created sp and loaded into 4 tables and used into tableau.
table will get data every two hours.