Error connecting stored procedure on the SAP HANA Database

[JULIAN21989]

I try to connect to SAP Business One on HANA, I need to use the import option, this is my connection:

And this is de error message: 

I have the correct ODBC drivers installed and when connected without SQL instructions it's run ok, but don't show the stored procedure:

Connection without SQL:

Result (Don't show procedure):

[amitchandak]

@JULIAN21989 , I doubt the call of proc is supported for that. It is supported for SQL server

[JULIAN21989 · Accepted solution]

I solved it by creating an ODBC connection in Power BI, for this to work you need to have the proper driver installed and configured.

Required driver and installation process:

https://blogs.sap.com/2021/03/19/connect-to-sap-hana-database-from-microsoft-power-bibusiness-intell...

I share the procedure I did:

https://www.youtube.com/watch?v=yxr7Gmpw59g 

I use this connection string:

currentschema=NAMEDB;driver={HDBODBC};serverdb=NAMEDB;servernode=IPSERVER:30015 

NOTE: If it doesn't work with the server ip, you can try putting the server name in the connection string.

[RodneydeBeer]

You are a star, scholar and gentleman! I had exactly the same problem and your solution worked perfectly!

Your effort to come back and give the solution is awesome.

Thank you!

[psathanapal]

what are those drives. from where we can get and how we need to setup. can you please tell me

[JULIAN21989]

These are the drivers:

https://blogs.sap.com/2021/03/19/connect-to-sap-hana-database-from-microsoft-power-bibusiness-intell... 

[JULIAN21989]

Thanks so much.

We have already used it in this way in other connections and it worked correctly, but it stopped working, is there any way to call a HANA Stored Procedure?