how can i reduce the clicks while passing stored procedures as Parameters

[Anonymous]

Hi Team,

I am passing the store procedure as a parameters. its showing the more Number of cliks to get the report Result. i am following  process  is

1. Edit parameters-one click

2. pass the parameters after click apply-second click

3.Apply the changes -third click

4 Run the procedure-fourth click

5.Refresh the report-5th click . this is the very lengthy  process to this much of clicks in a report

is there any possible ways to Reduce the more number of clicks.

[v-yuta-msft]

@Anonymous ,

Power bi is a analytical tool of data so it's not recommended to exec stored procedures in power bi desktop. I would suggest you and it's more simple to use SSMS and click "New Query" instead.

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.