Oracle DB Connectivity Issue

[GanesaMoorthyGM]

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 be installed do i need gateway, oracle db etc... kindly let me know what all are the essentials that need to be downloaded or installed

[rajendraongole1 · Accepted solution]

Hi @GanesaMoorthyGM  - can you install,  Oracle Data Access Components (ODAC),

youtube:

https://youtu.be/ClBQ3_p7T_A

Oracle .NET, Visual Studio, and VS Code ODAC Downloads for Oracle Database

or 

Oracle Instant Client Downloads

Add this to your System PATH

eg: C:\oracle\product\19.0.0\client_1\bin

port: 1521

check and configure the service name

Hope the above details helps.

[v-hjannapu]

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]

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]

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.

[rohit1991 · Accepted solution]

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).

[rajendraongole1 · Accepted solution]

Hi @GanesaMoorthyGM  - can you install,  Oracle Data Access Components (ODAC),

youtube:

https://youtu.be/ClBQ3_p7T_A

Oracle .NET, Visual Studio, and VS Code ODAC Downloads for Oracle Database

or 

Oracle Instant Client Downloads

Add this to your System PATH

eg: C:\oracle\product\19.0.0\client_1\bin

port: 1521

check and configure the service name

Hope the above details helps.

[AlexTheGreat]

Hi,

It seems that in your error message is a link to install the needed provider. Installing the provider will solve your problem 🙂

Hope it helps!