Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am running sql server stored procedure from Power BI and it does bring back the results when I manually set the parameters.
However it doesn't work when I define power BI parameters and try and use them instead.
Here is what I want to do,
1. Define Power BI parameters
2. Use them in SQL statement such as,
EXEC [dbo].[Some_Procedure]
@Date = PowerBIDefinedParameter
thanks.
Hi @Student225,
Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.
Best Regards!
Dale
share your script from advaned editor in power query, you need to use something like this to use parameter #"Parameter Name"
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Here is the code with manually typed variables.
How do I replace them with power BI parameters
for example @ValuationRunId = 0 replaced with Poower BI parameter @ValuationRunId = PowerBIParameter
let
Source = Sql.Database("SERVER", "DATABASE", [Query="#(lf)EXEC#(tab) [dbo].[PROCEDURE]#(lf)#(tab)#(tab)@COBDate = '2017-11-02',#(lf)#(tab)#(tab)@ValuationRunDefintion = 'Official EoD',#(lf)#(tab)#(tab)@ValuationRunId = 0,#(lf)#(tab)#(tab)@IgnoreZeroVolume = 0#(lf)#(lf)"])
in
Source
many thanks
Any suggestions.
try this, make changes highlighted below.
let Source = Sql.Database("SERVER", "DATABASE",
[Query="#(lf)EXEC#(tab) [dbo].[PROCEDURE]#(lf)#(tab)#(tab)
@COBDate = '" & #"your parameter" & "',#(lf)#(tab)#(tab)@ValuationRunDefintion = 'Official EoD',#(lf)#(tab)#(tab)@ValuationRunId = 0,#(lf)#(tab)#(tab)@IgnoreZeroVolume = 0#(lf)#(lf)"]) in Source
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |