Parameter passing to stored procedure dynamically with out edit parameter

[Raghuvardhan]

Hi All,

I Have Stored procedure along with Parameter (Date Parameter) . I have created Parameter in Power BI Desktop and passing parameter value to stored procedure Dynamically .

Here my questions are

1) Always I'm using edit parameter to pass value to my sp to fetch the records and along with by clicking  "Refersh data" warning message .

Currently, I am passing the Date value to the Parameter maually in Power BI deskTop to get the report updated .

Could you Please help if there is a way to dynamically pass this date from a date picker selection to the Stored procedure parameter.

Thanks

Raghu

[CheenuSing]

Hi @Raghuvardhan

Check the link

https://community.powerbi.com/t5/Integrations-with-Files-and/parameters-to-SP-or-Sql-query/m-p/58337

[Raghuvardhan]

Hi @CheenuSing

Thanks for your kind reply,

I have done all the  above steps , Even I can pass the parameter through the Desktop like Edit Queries-> Edit parameters -> there I'm passing value manually  . By clicking the "Apply Changes" warning message. after my data is refershing .

But , I need to avoid all the manual steps . 

Is there any possible way like, pass parameter value dynamically to my direct query (SP) and data has to be refershed based on given i/p parameter . can you please help me about this.

Thanks 

Raghu

[v-caliao-msft]

@Raghuvardhan,

Is there any possible way like, pass parameter value dynamically to my direct query (SP) and data has to be refershed based on given i/p parameter.

Based on my research, there is no such an option to allow us to achieve this automatically. Currently, we need to edit queries to change parameter value. If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.
https://ideas.powerbi.com/forums/265200-power-bi-ideas

Regards,

Charlie Liao

[ara0530]

What is this then?  I am also trying to do the same

https://www.youtube.com/watch?v=7XR6vhdqLCw&list=PLDzs1KO9UGLxv0unWQl4JU148rJr6y4aB&index=2&t=301s

[Raghuvardhan]

Hi Charlie Liao,

Thanks for your reply,

Based on my research, there is no such an option to allow us to achieve this automatically. Currently, we need to edit queries to change parameter value.

Like you mentioned above ,Is there any option like this in power bi service ? .

Thanks 

Raghu

[Juramirez]

hi @Raghuvardhan

Did you solve this? I'm having troubles with this. You can find my post here to see what i'm trying to do. Hope you can help me.

Regards

[Anonymous]

This can be achieved ony through pagination report in power BI

Regards

Basavaraj Dandothi

[ara0530]

https://www.youtube.com/watch?v=7XR6vhdqLCw&list=PLDzs1KO9UGLxv0unWQl4JU148rJr6y4aB&index=2&t=301s