Timestamp with timezone support in ODBC based connector

[hovaesco]

Hi,

Does the datatype Timestamp with timezone is supported in ODBC based connector? I'm getting below error in DirectQuery mode:

Error message from PowerBI:

PowerBI DirectQuery error: "OLE DB or ODBC error: [Expression.Error] We couldn't fold the expression to the data source. Please try a simpler expression.

I tried to add a code for this type to OdbcConstants.pqm accordingly to: https://github.com/microsoft/ODBC-Specification/blob/master/Windows/inc/sql.h#L229 - but it has no effect.

There is no reference to timezone types in sample OdbcConstants.pqm file: https://github.com/microsoft/DataConnectors/blob/master/samples/ODBC/SqlODBC/OdbcConstants.pqm

Thanks!