Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Raghuvardhan
Frequent Visitor

Parameter passing to stored procedure dynamically with out edit parameter

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

8 REPLIES 8
CheenuSing
Community Champion
Community Champion

Hi @Raghuvardhan

 

Check the link

 

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

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

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

 

@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

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

 

 

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
Not applicable

This can be achieved ony through pagination report in power BI

 

Regards

Basavaraj Dandothi

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.