Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Error ODBC when added merged columns

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(#"Add...
Need Help
StefanoGrimaldi's avatar
StefanoGrimaldi
Resident Rockstar
5 years ago

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's avatar
Anonymous
Not applicable
5 years ago

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's avatar
    StefanoGrimaldi
    Resident Rockstar
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

      = 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