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?
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.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.