Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

 

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    Yes, you should be able to do this with query parameters