concatenation of column not working in Direct Query with vertica

[Anonymous]

Concatenation of column not working in Direct Query with On-Prem Vertica.

Power BI Version used: 2.55.5010.581 64-bit (February 2018)

Steps:

1) Create Connection with On-Prem Vertica using Direct Query Mod.

2) Create new custom colummn and concatenate 2 columns in it

(Column = <TableName>[<ColumnName>]&<TableName>[<ColumnName>]

3) Try reading the data of customer column using the table component.

Expected Result: Data should get displayed.

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

Below is the screenshof for the reference of the error.

[v-jiascu-msft]

Hi @Anonymous,

As you know, the Direct Query is a performance critical mode and the connector Vertica(beta) is under development. Actually this feature is available in the Direct Query to SQL Server. I think it will be available in the feature. 

The workaround is quite simple that is doing concatenation in the Query Editor. I would suggest you file an idea here for the feature in DAX.

Best Regards,

Dale