Stored procedure in powerbi

[Anonymous]

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

[fmunar1985]

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?

[v-jayw-msft · Accepted 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