Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
@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