Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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
@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
@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
no
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
179 | |
108 | |
105 | |
71 | |
70 |