12-06-2018 10:36 AM
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?
12-06-2018 09:40 PM - edited 12-06-2018 09:44 PM
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.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
For learning resources/Release notes, please visit: | |