Reply
Highlighted
Frequent Visitor
Posts: 9
Registered: ‎10-17-2018

Possible to pass parameters from Power BI to a SQL stored procedure?

I want to pass two parameters (StartDate and EndDate) from a slicer in Power BI Service to a SQL stored procedure, then send the results of the query back to my Power BI dashboard using a dynamic query.  Is this possible?  If so, how can I do this?

Community Support Team
Posts: 6,916
Registered: ‎08-14-2016

Re: Possible to pass parameters from Power BI to a SQL stored procedure?

[ Edited ]

Hi @tgiard,

 

Nope, it is possible use query parameter to pass parameters to sql stored procedure, but you can't extract value from filter and slicer as query parameter.

 

BTW, stored procedure not support in directquery mode.

 

Regards,
Xiaoxin Sheng