Forum Discussion
Anonymous
6 years agoNot applicable
Paasing multiple parameters to stored procedure in Power BI
Hi
1) I have a Stored Procedure to execute in Query window in Power BI Import Mode, multiple parameters need to be pass (Dynamically) in order to execute this Stored Procedure.
EXEC sp_test India,20 -> this query works in Power BI as i am passing static values to the parameters .
But
EXEC sp_test @Country,@Value -> i need to pass values dynamically to these parameters from Power BI
- Yes, you should be able to do this with query parameters
1 Reply
- Greg_Deckler
Community Champion
Yes, you should be able to do this with query parameters