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

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!