Forum Discussion
parameters to SP or Sql query
Thank you so much. Will give this a go as soon as possible.
By the way, this work fine. Thanks so much. Now I need to find out how to update the parameters in PowerBI.com so that i can refresh the data as needed. Thanks again.
Guys do we've a solution for this, I've similar requirement, I've got four drop downs in my report
1. Country
2. State
3. City
4 Store
the navigation is working fine, but I've a requirement to take this to next level i.e. in each drop down I've option to select either one or all, now once the selection is made, I want to use this as a input parameter for a stored procedure which resides in my sql server database.
I understand that in the new query editor I can use the stored procedure but how do I populate the parameter from the drop down visualization i.e. slicer in my case (I can use some other visualization aslo), first will list country, second will have states, third will have city and fourth will have storeIDs, now I can either have all selected or any indivudial values and on the basisi of this select tion, my procedure should execute like below
exec dbo.myproc countryid = @countryvar, stateid = @statevar, cityID = @cityID, storeDi = @storeID
Hey, can you find any solution or workaround, to this? pls share in any