Connect Power Bi to Oracle Fusion

hello 

Please brief your requirement.

Are you trying to connect to Oracle Fusion Middleware components from Power BI.

Hi,

It is impossible as direct connection - but you can have it similar to scheduled export but with extended amount of data.

This can be done by using SOAP for OBI/BIP.  But you need some sort of middleware anyways, external server running the script or as in my case - MS Power automate.

First you need to learn how to extract the data from BI publisher:
https://docs.oracle.com/cd/E28280_01/bi.1111/e22259/webservices.htm#BIPDV002
Use soapUI (https://www.soapui.org/) application to test and develop connections to WSDL's mentioned in above link.

Create BIP sql report that will suit your needs. Use soapUI to get proper package back.

This guy describes the process nicely:

https://blogs.oracle.com/fadevrel/calling-bi-services-from-external-applications 

Keep in mind he uses obsolete WSDL link (use one from Oracle doc I placed above).

Then you need to rewrite working soapUI request code to app you're gonna use.

In powershell you can use Invoke-WebRequest or Invoke-restmethod.

In ms Power Automate you can use HTTP connector, post method with WSDL of your interest as URI, with single empty header SOAPAction and request code from soapUI in the body. It gets the job done.

Last point If you want huge amount of data extracted asynchroneously (I had to do it async due to mspa html request timeouts):

Use one SOAP request to schedule the report - you will get parent jobID back. Increment it and use to run getAllScheduledReportHistory which confirms if your incremented id is child of parent jobID received in first place.

Then run some until loop on getScheduledJobInfo to wait and confirm the file is ready. 

Finally use getScheduledReportOutputInfo to get document ID and getDocumentData to get the document (it is base64 encoded - ms flow allows to decode it using expressions: base64ToString() for xml, csv overal txt data or base64ToBinary() for other filetypes. For other apps than mspa you need to code something of your own). My output gets uploaded to sharepoint and sourced to PowerBI from there.

That way you can completely control what will be extracted from your fusion OBI by crafring BIP SQL yourself, by letting the process to schedule the report you will make it completely independed and waiting for report process/file preparation to be finished on its own.

Excuse me for quite a messy reply but I finished developing above just last week in my company so for me this is quite fresh and gamechanging knowledge I am yet to utilize in its full potential.

Kind Regards,

Matt

To determine which version of Power BI Desktop is installed, select File > About then check the Version: line. In the following image, a 64-bit version of Power BI Desktop is installed:

Installing the Oracle client
For 64-bit versions of Power BI Desktop, use the following link to download and install the 64-bit Oracle client.

I am after this functionality too. Has there been a solution in the 2 years since this was created? 

BI Connector connects Power BI Desktop and Service (and Report Server) to Oracle Fusion Analytics in minutes. You can now access the ERP, HCM, CX or SCM Subject Areas and Analysis reports in both Import and Direct Query modes!

The connector is Power BI Certified, and also retain the joins underlying the Subject Area tables in Power BI with simple steps. You don't have to create them from scratch in Power BI!

The connector enables seamless blending of your Oracle Fusion ERP, HCM, CX and SCM data with your other data sources in Power BI.

Hi There,

You can connect Oracle Fusion Directly to PowerBI using our "FusionLink" using JDBC/ODBC connector. Email me at "[email protected]" for a free trial.

Jatin