Forum Discussion
Dynamic parameter invoke by slicer
pjr1221 ,
"I want the user send the parameter value to the stored procedure by slicer. And I want to overwrite the data on the existing table, not the new table. I wonder if this is possible, and even after publishing on the web."
<--- I'm afraid the query parameter can't interact with the selected item in slicer. In addtion, if you want to replace the existing table, you need to modify the data source expression in advanced editor.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
pjr1221 ,
"I want the user send the parameter value to the stored procedure by slicer. And I want to overwrite the data on the existing table, not the new table. I wonder if this is possible, and even after publishing on the web."
<--- I'm afraid the query parameter can't interact with the selected item in slicer. In addtion, if you want to replace the existing table, you need to modify the data source expression in advanced editor.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-yuta-msft Hi,
If that's not possible, why is Stored Procedure used in Power BI ?
Best Reguards,
pjr1221
pjr1221 ,
I would suggest you to refer to doc below:
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
That article is from 2016. Have there been no updates to improve the end user experience since then?
