How do you do a parameter query when not using Microsoft Query?

This works! You beautiful genius!

Here's the code I ended up using. The only thing I'm changing are the server IP and database name:

let
StartDate = Excel.CurrentWorkbook(){[Name="StartDate"]}[Content][Column1]{0},
EndDate = Excel.CurrentWorkbook(){[Name="EndDate"]}[Content][Column1]{0},
Source = Sql.Database("192.168.1.1", "MyDatabase", [Query="SELECT TOP 1000 * FROM Invoices#(lf) WHERE InvoiceDate BETWEEN '" & DateTime.ToText(StartDate) & "' and '" & DateTime.ToText(EndDate) & "' ORDER BY WorkDate DESC"])
in
Source

For anyone else trying to figure out what the heck is happening here, the reason the " and ' are so critical and finnicky is because they're breaking up the text to send it to the right place. The " characters are switching between the primary coding language (M, I think) and SQL, and the ' need to be passed to SQL for the dates to work.

In straight SQL this query would look something like:

SELECT * FROM Invoices WHERE WorkDate BETWEEN '2020-01-01' AND '2020-02-01'

So we need to keep the ' between a pair of " so they're passed to SQL. If they're missing it'll throw an error. The & are concatenating the date values into the string that eventually is passed to the SQL engine. 

Hopefully that makes sense. 

I'm still a little unclear why there's the need for [Content][Column1]{0} after declaring each variable, but whatever. 

Thanks again, bwdur 

bwdur 

I guess the issue was since on the time of previous post Power Query returned Excel date as date, and now as datetime. I'd don't rely on default behavior, it's better to force date value and use date format converting dates to texts, like

let
    Source = Excel.CurrentWorkbook(),
    StartDate = Date.From(Source{[Name="StartDate"]}[Content][Column1]{0}),
    EndDate = Date.From(Source{[Name="EndDate"]}[Content][Column1]{0}),

    SQLstart = Date.ToText(StartDate,"yyyy-mm-dd"),
    SQLend = Date.ToText(EndDate,"yyyy-mm-dd")
...