Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |