Tuesday, June 3, 2025

Power BI - How to connect to Oracle Database

 Steps to Connect to an Oracle Database


  1. Open Power BI Desktop

  2. Click on Home > Get Data and search for Oracle Database.

  3. Select Oracle Database and click Connect.


  4. You'll be prompted to enter the database connection details:

  5. Use the format <Host>:<Port>/<ServiceName> & Click Ok.

Here,

Oracle Server is SALESDB.CloudIndia.com, 1529 is the port number, and SALESGRP is the service name.

  1. If authentication is required, enter your username and password.


Click OK to proceed.

  1. Power BI will establish the connection and display available tables in the database. Choose the required tables and Load or Transform Data as needed.


  2. Once the data is loaded into Power BI, you can start building visualizations, reports, and dashboards using the imported data.

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)