Hi all,
Using Excel Microsoft 365.
I created a Stored Procedure in Management Studio - tested - works.
Now I am trying to call the sp from Excel Power Query and pass the parameter
I keep getting error
Expression.SyntaxError: Invalid Identifier
I don't see what is worng with my M Script - do you see any problems?
let
DepartmentName=Excel.CurrentWorkbook(){[Name=”param”]}[Content]{0}[#”Department”],
Source = Sql.Database("localhost\SQL2017INSTANCE2", "AdventureWorksDW2017",
[Query="exec [dbo].[usp_SelectEmployees]'"
& DepartmentName
&"'"])
in
Source
Thanks,
w
Bookmarks