cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Neero Frequent Visitor
Frequent Visitor

Re: How to call/execute a oracle stored procedure from powerbi desktop

Thanks a lot for the comments, and I think I will do some workaround as you mentioned

RakeshP Regular Visitor
Regular Visitor

Re: How to call/execute a oracle stored procedure from powerbi desktop

Not able to call/execute ORACLE stored procedure.

 

Are there any one who sucessfully call/executed ORACLE stored procedure and used the ouptut as data in power bi??

Highlighted
RakeshP Regular Visitor
Regular Visitor

Re: How to call/execute a oracle stored procedure from powerbi desktop

Are there any one?

yscheng Occasional Visitor
Occasional Visitor

Re: How to call/execute a oracle stored procedure from powerbi desktop

Yes, I have sucessfully invoked ORACLE stored procedures and used th return result sets as data in Power BI.

 

For instance, my Oracle package/sp code:

CREATE OR REPLACE PACKAGE BODY MY_SCHEMA.MY_PACKAGE IS

PROCEDURE MY_STORED_PROCEDURE
(
inParam1 DATE,
inParam2 PLS_INTEGER,
RC1 OUT SYS_REFCURSOR
) IS
BEGIN
...

OPEN RC1 FOR
SELECT ...;
END MY_STORED_PROCEDURE;

END MY_PACKAGE;

 

Then, following is all my Power Query code:

 

let
    Source = Json.Document(Web.Contents("http://dbwebapi.mysite.com/oradev/my_schema.my_package.my_stored_procedure/json?inParam1=2016-04-22&inParam2=100")),
    ResultSet1 = Table.FromRecords(Source[ResultSets]{0})
in
    ResultSet1

To get this point, I installed a generic Web API proxy for Oracle which automatically translate between Oracle stored procedures and Web API, it requires no coding and no configuration (except the database connection string). You can have a look at https://github.com/DataBooster/DbWebApi/wiki and focus on https://github.com/DataBooster/DbWebApi#power-query-client.The installation of the proxy service can be downloaded from https://dbwebapi.codeplex.com/releases.

 

Hope this would help.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 54 members 1,063 guests
Please welcome our newest community members: