Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I have a stored procedure in my database which accepts parameters.
lets just say it is like this:
execute stored_proc @param
Is it possible to pass the parameter dynamically from a measure/column based on user's selection to the stored procedure?
For eg: User selects '5' in the slicer in the powerbi report.
Can I pass this 5 to the stored procdure dynamically?
like this:
>> execute stored_proc 5
Any help is appreciated. Thank you
Solved! Go to Solution.
Hi @Anonymous ,
I don't think so. The slicer is a visual, the selected value can only be use in measure.
Best Regards,
Jay
I have a doubt about the parameters in BI.
I have the next store exec Proc Proc_Demo where dFecha = @Fecha
Now in the powerbi i've already did a function with the parameter but i can't make a relation with other tble.
What i need to do is bassed on this parameter has a date in other table that i will use as a filter so in that way the user can refresh the store with that date.
Have any idea how to do that?
Hi @Anonymous ,
I don't think so. The slicer is a visual, the selected value can only be use in measure.
Best Regards,
Jay
User | Count |
---|---|
100 | |
89 | |
82 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |