Share via

Is there a cleaner way to connect Power BI to Oracle Fusion?

Utkarsh Pandey 0 Reputation points
2025-08-11T09:22:39.71+00:00

We're using BICC and BI Publisher exports to pull Fusion data into Power BI. It works… sort of. But it’s messy -  lots of manual steps, stale data, and fragile file-based pipelines.

I came across a method  that does direct connectivity from Power BI to Fusion, skipping staging and ETL/OIC entirely. Supposedly works with Power BI Fabric and ADF too, with incremental refresh.

__There’s a deep dive session about it on Aug 19, 9–10 AM PST with some live demos. If anyone here is working with Fusion + Power BI, might be worth a look.
__
https://watch.getcontrast.io/register/bi-connector-from-fusion-to-warehouse-without-the-headaches?utm_source=Oracle-Community&utm_medium=organic&utm_campaign=august_webinar

Developer technologies | Windows Forms
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Varsha Dundigalla(INFOSYS LIMITED) 795 Reputation points Microsoft External Staff
    2025-08-12T06:52:15.6733333+00:00

    Yes, there are cleaner and more efficient ways to connect Power BI to Oracle Fusion Cloud beyond using BICC and BI Publisher with manual file loads. These modern approaches focus on automation, real-time data access, and reduced maintenance.

    Direct API Pull into a Warehouse Use Oracle Fusion Cloud REST APIs (or SOAP if needed) to fetch data directly into Azure Data Lake, Synapse, or Power BI Fabric. Tools like Azure Data Factory (ADF) with REST connectors or Power BI Dataflows with custom connectors support incremental refresh, allowing only new or changed data to be pulled.

    Managed Connectors Third-party connectors such as BI Connector, Datalytics, Magnitude Simba, and Hevo automatically map Fusion APIs into relational tables, handle token refresh and pagination, and push data into SQL-based targets. Power BI then connects to these targets using native SQL connectors, eliminating fragile staging scripts.

    Using Autonomous Data Warehouse (ADW) or Fusion Analytics Warehouse (FAW) Oracle’s FAW and ADW mirror Fusion transactional data in a BI-ready schema. Power BI can connect directly to ADW using Oracle connectors, enabling faster refreshes and stable schemas.

    BI Connector + Microsoft Fabric Pipelines BI Connector supports both Import and DirectQuery modes and preserves Fusion’s subject area joins. When combined with Fabric Dataflows (Gen2), it enables full automation. Incremental refresh is managed using lookup tables in Azure SQL that define refresh type, watermark columns, and frequency. Parent pipelines orchestrate schedules while worker pipelines execute table-specific loads.

    REST API Connections (Custom) While REST APIs can be used directly, they require custom scripting for authentication, pagination, and schema handling. This method is best suited for ad-hoc pulls rather than enterprise-scale pipelines.

    Implementation Prerequisites

    • Install Oracle Client for Microsoft Tools (OCMT) on Power BI Desktop or gateway machines.
      • Use On-Premises Data Gateway for cloud refreshes.
        • Ensure query folding is enabled to push transformations down to Oracle.
        Security and Governance Use Azure Key Vault for managing credentials securely in pipelines. These approaches reduce latency, eliminate manual exports, and support scalable, cloud-native integration.

    This setup avoids CSV/XML downloads, supports automated refreshes, and ensures schema stability. It’s easier to document, govern, and maintain.
    Let us know if you need any further help with this. We’ll be happy to assist further if needed.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.