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(#"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?

 

Need Help

4 Replies

  • 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.