cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
the606
Helper I
Helper I

Passing a parameter to a query in Power Query for a SQL stored proc

Hi,

 

I need to pass a parameter to be sent to a stored proc in SQL. I have created a parameter on an excel sheet looking at a field called date_parameter. This is showing up as a parameter in power query, the @asatdate  works if i put in a date instead of the parameter (example = Sql.Database("IP_Address", "DB_NAME", [Query="execute UDEF_BI_DEF_AGED_DEBTORS_EXTENDED @ASATDATE = '06/08/2021'"])

 

I have tried various mmethods of passing this across and i cant seem to get the styntax correct.

 

Any ideas?

 

= Sql.Database("IP_Address", "DB_NAME", [Query="execute UDEF_BI_DEF_AGED_DEBTORS_EXTENDED @ASATDATE = Parameter[Date_Parameter]{0}"])

 

This is my latest try!

1 ACCEPTED SOLUTION
v-kelly-msft
Community Support
Community Support

Hi  @the606 ,

 

You can create a custom function in power query then use it as parameter to execute a Stored Procedure.

Check the reference below:

 https://docs.microsoft.com/en-us/power-query/custom-function

 

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

View solution in original post

2 REPLIES 2
v-kelly-msft
Community Support
Community Support

Hi  @the606 ,

 

You can create a custom function in power query then use it as parameter to execute a Stored Procedure.

Check the reference below:

 https://docs.microsoft.com/en-us/power-query/custom-function

 

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

View solution in original post

CNENFRNL
Community Champion
Community Champion

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors