Looking for help injecting a parameter into SQL before it queries the tables, to bring back results. RRS feed

  • Question

  • What I'm working with:

    Excel O365 with Power Query.  DNS ODBC connections.  

    The question I have is, how do I use a parameter to retrieve my data?  In the simplest form, my query would look like:

    Select * From locations Where custid = '12345' And facility = 'ABC'

    I have setup the custid and facility parameters in Power Query, but I do not know how to write the SQL so it pulls in the parameters.  If that is even the correct method.  My parameters are not defined in a table, only in the Parameters tool  Any help would be appreciated.

    Thursday, June 13, 2019 7:03 PM