Trying to pass two parameters to stored procedure

[DeBIe]

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

[lukiz84 · Accepted solution]

is it the same error when you remove 

, CreateNavigationProperties = false

?

[lukiz84 · Accepted solution]

is it the same error when you remove 

, CreateNavigationProperties = false

?

[DeBIe]

it's alive, IT's Alive, IT's ALIIIIIVE!

Thank you so much for saving my day.

[DeBIe]

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

[lukiz84 · Accepted solution]

you're welcome - please mark my post as the solution 🙂

[lukiz84]

You are missing the " after &BatchNumber"'

[DeBIe]

Hey @lukiz84 

Thanks for replying. Still I get an error

[lukiz84]

you need a comma before CreateNavigationProperties...

[DeBIe]

@lukiz84 

Still an error. Any idea?

[lukiz84]

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

[DeBIe]

@lukiz84 

Thanks. No errors in the syntax! Unfortunately I receive this expression error now. Any thoughts?