How to pass and INT parameter to stored procedure query in pbi

[RogerSteinberg]

Hi,

I have the following query that executes a stored procedure in sql server. I would like to pass an INT parameter that I created in power query called CountryNumber

let
    Source = Sql.Database("server_name", "db_name", [Query="execute spTest ", CommandTimeout=#duration(0, 1, 0, 0)])
in
    Source

How can I do this. Please don't answer with a link to another page. I haven't found one that shows how to include INT

Ty

[amitchandak · Accepted solution]

@RogerSteinberg , It should be like

let
Source = Sql.Database("server_name", "db_name", [Query="execute spTest 1", CommandTimeout=#duration(0, 1, 0, 0)])
in
Source

//In case you want to give parameter

let
Source = Sql.Database("server_name", "db_name", [Query="execute spTest "& Number.FromText(vInput) , CommandTimeout=#duration(0, 1, 0, 0)])
in
Source

https://www.c-sharpcorner.com/article/execute-sql-server-stored-procedure-with-user-parameter-in-pow...

[Greg_Deckler]

@RogerSteinberg - So this doesn't work?

let
    Source = Sql.Database("server_name", "db_name", [Query="execute spTest CountryNumber", CommandTimeout=#duration(0, 1, 0, 0)])
in
    Source

[RogerSteinberg]

no