Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 2 |
| User | Count |
|---|---|
| 11 | |
| 10 | |
| 7 | |
| 7 | |
| 6 |