Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hey all,
I think I tryed every possible solution on the web but I just can't get it to work and I decided to post my problem here before hitting my head to the wall multiple times.
I want to execute an stored procedure with two parameters. Adding one parameter works fine, but I can't get it done with two parameters. Any idea what is wrong with my code?
let
Source = Sql.Database(sqlserver, "Database_01", [Query="execute sp_BE_FindBatch '"&ClientName"', '"&BatchNumber"' CreateNavigationProperties=false])
in
Source
Thank you for your time.
Raoul
Solved! Go to Solution.
is it the same error when you remove
, CreateNavigationProperties = false
?
you're welcome - please mark my post as the solution 🙂
is it the same error when you remove
, CreateNavigationProperties = false
?
it's alive, IT's Alive, IT's ALIIIIIVE!
Thank you so much for saving my day.
This is the solution code for others who face the same problem
let
Source = Sql.Database(sqlserver, "Database_01", [Query="execute sp_BE_FindBatch '"&ClientName&"', '"&BatchNumber&"'"])
in
Source
you're welcome - please mark my post as the solution 🙂
You are missing the " after &BatchNumber"'
you need a comma before CreateNavigationProperties...
ah sorry, it has to look like this:
let
Source = Sql.Database(sqlserver, "Database_01", [Query="execute sp_BE_FindBatch '"&ClientName&"', '"&BatchNumber&"'", CreateNavigationProperties=false])
in
Source
you have to Add "&" after ClientName and BatchNumber
Thanks. No errors in the syntax! Unfortunately I receive this expression error now. Any thoughts?
User | Count |
---|---|
102 | |
84 | |
77 | |
70 | |
67 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |