ODBC connection to Denodo, using a table as a parameter

[gckcmc]

Datanuts,

I can connect to Denodo, with a syntax like this:

= Odbc.Query("dsn=DenodoODBC", "SELECT * FROM ""MyDataInterface"" WHERE ""ParameterXX"" = 'FUBAR'")

My question: I want to use a query (a table of values I've built) that replaces FUBAR, so I don't have to hard code the values.  Anyone know the VDL/Denodo/ODBC syntax to address that?

[v-frfei-msft]

Hi @gckcmc ,

I think parameter can help you in your scenario. Please refer to this blog.

https://powerbi.microsoft.com/fr-fr/blog/deep-dive-into-query-parameters-and-power-bi-templates/