Paasing multiple parameters to stored procedure in Power BI

Anonymous — Wed, 08 Apr 2020 18:38:29 GMT

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

Re: Paasing multiple parameters to stored procedure in Power BI

Greg_Deckler — Wed, 08 Apr 2020 18:53:11 GMT

Yes, you should be able to do this with query parameters

topic Paasing multiple parameters to stored procedure in Power BI in Developer

Paasing multiple parameters to stored procedure in Power BI

Re: Paasing multiple parameters to stored procedure in Power BI