Forum Discussion

GanesaMoorthyGM's avatar
GanesaMoorthyGM
Helper II
1 year ago
Solved

Oracle DB Connectivity Issue

Hi all, So first time im trying to connect with Oracle DB, This one appears  After Clicking Okay, I tried toconnect with Server Name, this appears   Help me with this What should b...
General Comment
Need Help
Tutorial Requests
  • rohit1991's avatar
    rohit1991
    1 year ago

    Hi GanesaMoorthyGM ,

    1. Install the Oracle Client Download and unzip the Oracle Instant Client (64-bit) from Oracle’s official site (the Basic package is enough). You don’t need to install the full Oracle database, just the client.

     

    2. Add the Client to Your System PATH After extracting, add the path to your Instant Client folder (e.g., C:\oracle\instantclient_21_13) to your Windows system environment variable called PATH.


    3. Make Sure Everything is 64-bit Power BI Desktop is almost always 64-bit now. If you install a 32-bit Oracle client by mistake, it simply won’t work.

     

    4. Connect in Power BI Open Power BI Desktop, choose the Oracle Database connector, and use this kind of server name: hostname:1521/servicename  Example: oracleserver.mydomain.com:1521/XEPDB1

     

    5. Gateway for Scheduled Refresh If you plan to refresh your dataset in the Power BI Service (cloud), the machine running your Power BI Gateway needs the Oracle client installed too (same steps as above).

v-hjannapu's avatar
v-hjannapu
Community Support
1 year ago

Hi GanesaMoorthyGM,

I would also take a moment to thank  rohit1991  , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Best Regards,
Harshitha.

  • v-hjannapu's avatar
    v-hjannapu
    Community Support
    1 year ago

    Hi GanesaMoorthyGM,
    I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.


    Regards,
    Harshitha.

    • v-hjannapu's avatar
      v-hjannapu
      Community Support
      1 year ago

      Hi GanesaMoorthyGM,

      I wanted to follow up and see if you have had a chance to review the information that was shared. If you have any additional questions or need further clarification, please don’t hesitate to reach out. I am here to assist with any concerns you might have.

      Regards,
      Harshitha.