Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet 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
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
Check the link
https://community.powerbi.com/t5/Integrations-with-Files-and/parameters-to-SP-or-Sql-query/m-p/58337
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
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
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
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
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
This can be achieved ony through pagination report in power BI
Regards
Basavaraj Dandothi
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
88 | |
85 | |
82 | |
65 | |
49 |
User | Count |
---|---|
138 | |
110 | |
104 | |
66 | |
64 |