Error ODBC when added merged columns

[Anonymous]

Hi ,

I got this error ODBC: ERROR [42000] [SAP AG][LIBODBCHDB DLL][HDBODBC] Syntax error or access violation;257,  when I inserted step for merged columns.

Ex inserted step: = Table.AddColumn(#"Added Custom", "Sold To", each Text.Combine({[#"Sold To Key"], [#"Sold To Desc"]}, " "), type text)

This error appears only on some users laptop, and only since recently, in Excel and/or PoweBI.

I tried two different laptop with the same credentials, one was having the issue on PowerBI and the other has the issue in Excel.

We checked security and Drivers version (HDBODBC and SAP HANA for MS Excel) and still no clues about what causing this error.

The DataBase is SAP HANA.

Any ideas to what could cause the trouble and how to solve it?

[StefanoGrimaldi]

you using a coustom made conector or a Hana Database conector from power bi?

also some example of the query steps before and after the problem could be usefull to find the issue if possible. 

[Anonymous]

I use Hana Database connector.

Steps before the probelm is Added items, works fine I can see the data from the Query,

then Inserted merged column = generate the error.

No steps after

[StefanoGrimaldi]

try a mor simply approach to see what happend instead of using the combine function use a costum column like this = Column1&"-"&Column2 

and lets see what error says over here. 

also try loading the query to the model an see the full table of data without any step.

[Anonymous]

= Column1&"-"&Column2 give the same Error message,

I also tryed  =Column1&Column2  and thid works fine, Looks like it dosn't like the double quote " " and columns combination