topic Re: How can we call SAP HANA Stored Procedure in power bi in Developer

How can we call SAP HANA Stored Procedure in power bi

psathanapal — Tue, 08 Nov 2022 16:00:30 GMT

Hello Team,

How can we call SAP HANA Stored Procedure in power bi. below is call statement with parameters.

call "Test"."Self.CONTRACT::Procedure"('PROD01624','Where-Used')

but facing below issue. how can i use this in power bi

need your help on this...

Thanks,

Prashanth.

Re: How can we call SAP HANA Stored Procedure in power bi

psathanapal — Wed, 09 Nov 2022 05:40:39 GMT

Any one had idea on this issue. if had a solution please let me know

Re: How can we call SAP HANA Stored Procedure in power bi

Anonymous — Wed, 09 Nov 2022 09:01:49 GMT

Hi @psathanapal ,

According to the error I think you may check the grammer near ".".

Please check the blog as below to learn more details about SQL statement in Power BI.

For reference: Execute SQL Server Stored Procedure With User Parameter In Power BI

And you may refer to this offical blog to learn more details about SAP HANA Database Connector.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: How can we call SAP HANA Stored Procedure in power bi

Anonymous — Wed, 09 Nov 2022 14:23:32 GMT

You were able to solve the problem?

I have the same problem 😐:

https://community.powerbi.com/t5/Desktop/Error-connecting-stored-procedure-on-the-SAP-HANA-Database/m-p/2895478#M995275

Re: How can we call SAP HANA Stored Procedure in power bi

Anonymous — Wed, 09 Nov 2022 16:29:48 GMT

Hi dear, 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.

I share the procedure I did:

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.

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

Re: How can we call SAP HANA Stored Procedure in power bi

Anonymous — Wed, 09 Nov 2022 16:33:16 GMT

I solved this:

https://community.powerbi.com/t5/Desktop/Error-connecting-stored-procedure-on-the-SAP-HANA-Database/m-p/2895838/highlight/true#M995388

Re: How can we call SAP HANA Stored Procedure in power bi

psathanapal — Fri, 11 Nov 2022 06:02:11 GMT

Thanks Julian,it worked for me...

now iam trying to bind a slicer field to parameter . as shown below screen. so that user can dynamically select the input value(it will directly hit to my mquery).

below is screen from google.

but i tried to do bind parameter in my power bi desktop. iam not able to see that bind option.

below is my screen. where i can see bind to parameter option.

please help me on this...

version iam using is shown in below screen

Re: How can we call SAP HANA Stored Procedure in power bi

Anonymous — Tue, 15 Nov 2022 16:43:45 GMT

Hi dear,

I don't know how to do it, but I found this, maybe it can help you:

https://learn.microsoft.com/pt-pt/power-bi/connect-data/desktop-dynamic-m-query-parameters