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

[Anonymous]

I want to pass two parameters (StartDate and EndDate) from a slicer in Power BI 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?

[v-juanli-msft]

Hi @Anonymous

It doesn't support to set a slicer (like a default slicer visual) in Power BI Service to work as parameters.

Hoever, you could also use parameters in Power BI Service.

Using the Power BI Service Parameters to change connection strings 

Using Parameters in Power BI

Best Regards

Maggie

[Stachu]

have a look at these
https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery
https://community.powerbi.com/t5/Desktop/Calling-SQL-stored-procedure-with-Direct-Query/td-p/224831

[Anonymous]

@Stachu,

Thank you for the links.  I'd like to clarify that I want to I want to pass two parameters (StartDate and EndDate) from a slicer in Power BI to a SQL stored procedure, then send the results of the query back to my Power BI dashboard.  I want to do this in Power BI Service, not desktop.

[parry2k · Accepted solution]

@Anonymous you cannot pass slicer value to underline query, you can add parameters in your power query and use those parameters value to pass to your underline query.