HOW TO CONNECT ORACLE CLOUD INFRASTRUCRE OBJECT STORAGE FROM MICROSOFT POWER BI TOLL.

[Govardhana]

Team,

I have a requirement to read the Parquet file stored under ORACLE CLOUD INFRASTRUCTURE (OCI) OBJECT STORAGE under buckets , my data resides. So i'm checking: can we read these data file from Oracle Object Storage in MS Power BI tool and can we construct new reports?

[Govardhana]

Thanks, Sahir! for acknowledging my question.

Let me explain Use case: I'm exporting Fusion Data Intelligence Analytics needed warehouse tables/objects by using the inbuilt ETL extract feature, and that extracts all the needed objects under OCI Buckets in Object Storage in form of Data (Parquet format) and Metadata (Avro format). Now I want to leverage these objects into the MS Power BI desktop tool to avoid using any ETL tools to reduce the commercial purpose.

Hope you're clear with my use case.

One more question: is this OCI Object Storage option available in the PRO or Premium version?

Thanks,

Guru 

[Sahir_Maharaj]

Hello @Govardhana,

If you have access to Oracle's OCI Data Integration or Oracle Autonomous Data Warehouse (ADW), you can integrate Object Storage data with Power BI through a database or ODBC connection.

1. First, use OCI Data Integration or Data Flow tools to load Parquet data into an Oracle ADW table.

2. Then, set up a direct query or import mode connection to ADW (Get Data > Oracle Database in Power BI Desktop)

3. Enter the ADW connection string and credentials - query the loaded data and build your reports.

Hope this helps.