Refresh Data set from MS SQL Server stored procedure using parameters

[mpandita]

Hello,

I am trying to refresh Dataset from MS SQL Server stored procedure Using parameters (mostly start date and end date).

Can anyone provide me an insight of the options available and their implementation?

It would be great if you can provide some examples for the same.

Thanks,

Manik

[v-yuezhe-msft · Accepted solution]

@mpandita,

Do you want to call stored procedure with parameters in Power BI Desktop? If so, please check my reply in the following similar thread.
https://community.powerbi.com/t5/Integrations-with-Files-and/parameters-to-SP-or-Sql-query/td-p/5773...

However, if you want to refresh the dataset which data source is dependent on parameters in Power BI Service, it is not currently supported. You can vote the following similar ideas.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9312540-make-functions-refreshabl...
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13820190-power-bi-online-query-pa...

Regards,
Lydia