ODBC dynamic parameterization

[mshoai]

Hello,

My source data comes from ODBC query. I would like to add dynamic parameters from an excel file to the query.

Eg., 

Query:

Odbc.Query("dsn=SB", "SELECT ALL A.CONO15, B.CONO05 FROM GT.PLOPITMS A LEFT OUTER JOIN GT.PLP05 B ON A.CONO15 = B.CONO05 AND A.SUPN15 = B.SUPN05 WHERE A.CONO15 IN ('G7','G8') AND B.GCTL05 IN ('242221000000', '24224001XDXB') AND A.BBAL15 <> 0 AND A.ETYP15 IN ('CA', 'JL') ORDER BY A.SUPN15 ASC")

Excel Data:

Lib	Code	Code
GT	G7	G8
GS	F1	6S

In Place of GT.PLOPITMS i want to pass values from Excel column(Lib).

and in place of A.CONO15 IN ('G7','G8') i want to pass values from Code columns.

[ND_Pard]

Refer to: How To Parameterize Your Power Query | How To Excel

It may provide you with what you're looking for ...

Good Luck.