How to write direct query with parameters to execute a stored Procedure or a workaround

[Anonymous]

Hi,

How to write direct query with parameters to execute a Stored Procedure.

Thanks

[Anonymous]

Thanks a lot! It answered my questions.

[v-kelly-msft · Accepted solution]

Hi @Anonymous ,

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!