Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How can a third party reporting software Power BI be connected to Oracle Reports in Fusion

Received Response
149
Views
4
Comments
GaneshPagare
GaneshPagare Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

Summary:

One of my client is using Power BI for reporting purpose they want to continue using power BI with fusion on a Realtime basis , So is there a way to sync up Power BI with Oracle fusion Database to have Realtime data in power BI from Fusion

Content (required):

How to connect Power BI with Fusion Reports

Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Tagged:

Answers

  • Raghavan p-Oracle
    Raghavan p-Oracle Rank 5 - Community Champion

    Fusion BI - How to Connect Power BI Desktop to Fusion DB (Doc ID 2204117.1)

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach

    No it is not possible get a database connection to the oracle cloud applications database in real time using a third party tool such as microsoft power BI. You can use oracle business intelligence to view data real time that you get out of the box when you buy oracle cloud applications as software as a service (OTBI). And if you also have oracle analytics cloud (OAC) as a platform as a service then that does comes with a SaaS "connector" to get real time data visualisations from your oracle cloud applications with data security. But if you want to view it in PBI then one solution is to first extract the data you need perhaps using the out of the box business intelligence cloud connector (BICC) that you get free with your oracle cloud application.

  • Kishore_Kumar
    Kishore_Kumar Rank 1 - Community Starter

    Hi,

    Thank you for providing the approach to connect Power BI with oracle fusion. Could you please share the detailed steps or reference document accomplish the connection with BICC.

  • Gaurav Bharadwaj-Oracle
    Gaurav Bharadwaj-Oracle Rank 6 - Analytics Lead
    edited Jul 21, 2025 4:05AM

    @Kishore_Kumar
    BI Cloud Connector is a utility that is bundled with your Fusion Applications.
    Its used to extract large amounts of data in CSV files.

    These CSV files can then be imported into any tool of your choosing to further process or analyze.
    You may need to do some formatting on top of it depending on your specific usecase.

    You can read about BICC and how to use it here.

    Regards,
    Gaurav