Forum Discussion
Helper IIOracle 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 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
Hi GanesaMoorthyGM - can you install, Oracle Data Access Components (ODAC),
youtube:
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.
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).
6 Replies
- AlexTheGreat
Resolver II
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! - rajendraongole1
Super User
Hi GanesaMoorthyGM - can you install, Oracle Data Access Components (ODAC),
youtube:
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.
rohit1991Hi 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).
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.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.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.
