How can we call SAP HANA Stored Procedure in power bi

[psathanapal]

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.

[Anonymous]

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 

[psathanapal]

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

[Anonymous]

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 

[Anonymous]

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

[psathanapal]

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

[Anonymous]

I solved this:

https://community.powerbi.com/t5/Desktop/Error-connecting-stored-procedure-on-the-SAP-HANA-Database/...

[Anonymous]

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.