Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Refer to: How To Parameterize Your Power Query | How To Excel
It may provide you with what you're looking for ...
Good Luck.