Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

SAP HANA Navigator

Hello, Im trying to make dicret connection to my sap hana express. I got the connection and it seems that everyting is going well(Or that's what i believe) . Anyway after i connect to the sap hana da...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Well, ya the answer was right! 

    The sulotion was actually there, just install the Client of SAP HANA 

    and add that connection to ODBC Administrator with correct ip and port which usually 3<instance number> 13  (ip:3<IN>13)

    and I choose the system username and password "Not the best choice " and when the connection succeed, just in the Get Data in Power bi choose Other-> ODBC .
    That is how did it work for me . 

dexterz's avatar
dexterz
Helper II
9 years ago

you can only see the cube in contents by hana drive.

want to see the table should through the odbc drive.

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    9 years ago
    dexterz wrote:

    you can only see the cube in contents by hana drive.

    want to see the table should through the odbc drive.

    dexterz

    Thanks for that information! Is there any documentation talking about this limitation?

  • psdhillon1's avatar
    psdhillon1
    Helper I
    4 years ago

    Hi, 

    I am facing same issue & able to connect using ODBC, Though with ODBC connection, i can see all the raw data tables not the polished tables, as i can see in many tutorial videos. When i check with Hana connector, the screenshot given above is on my screen, No Cube is visible, but i can see the cubes in different packages in hana studio. it looks like it is priviledge issues, but i am not sure what priviledge i shoudl eb asking from hana team. Please suggest