Power BI: How to Connect to Oracle Database (Part 3)

Part 3, Advanced Topics
1. How to switch from Windows Store Version to EXE version
2. How to find my Oracle Home (Oracle Installation location)

3. How to use Windows Telnet to test my connectivity to the database

[@fatihsevinc9327]

hi Matthew, i want to connect oracle 11g with power bi , but there is no odac 11g on oracle page. i try odac 12 but it doesnt work. how can i connect.

[@arkabose89]

you wrote copy the dll file from the oracle home directory. but where to paste it?

[@colonelred7455]

there: product\12.2.0\client_1\bin

[@khurshidalam4928]

my question is how to connect power bi with oracle using linux operating system

[@parvindersingh7152]

Hi Matthew, I am trying to connect Power BI to an oracle cloud database , but am un-able to do so , have followed all steps , the error is "Oracle: ORA-12537: TNS:connection closed". Request some help from you

[@fishleaf]

Hi, it seems you don't have the connectivity to the Oracle Server. Some immediate action you can take is to talk to your DBA Team to ask them open the firewall to your laptop/server. You can check the connectivity test guide from Part 3 of the video: kzbin.info/www/bejne/mJCwnKZogqdnfdk Alternatively, you can submit a ticket to Power BI Official Support team for additional help and deep dive! admin.powerplatform.microsoft.com/newsupportticket/powerbipro Hope this information helps!

[@parvindersingh7152]

@@fishleaf Thanks a lot Mathew for your reply The issue of connectivity was because I was trying to use the 2nd way recommended by you (by putting the host ID: Port/ SID), my database also had SSL CERT configured , hence was unable to connect this way. However was able to connect using the 1st method which checks the wallet credentials. Coming back to the 2nd method, tried adding the SSL parameter to the string, but was unsuccessful as power BI does not accept strings greater than 128 characters , is there a way to handle this ? Also once connected the speed of Oracle data import is really bad, any settings I need to change Your help is highly appreciated

[@fishleaf]

@@parvindersingh7152 For your first question, unfortunately it might be a hard limit which we can't bypass. In this case, I would stick with TNS name way which is working! Maybe you can try to switch the CNAME to the Scan IP instead to reduce the word count -- this might not work well. For your 2nd question -- I had the same complain since 6 years ago!! Please see my original post on the community community.powerbi.com/t5/Desktop/Very-Slow-Oracle-Connection-Speed/td-p/72510 It seems there are some "cooperate battle" or technical issue and Oracle and Microsoft can't work together to have the best user experience. My suggest is to make sure my Gateway Server or Local Desktop is in/as near as the same network (data center, AZ, or at least region) of the Oracle DB to at least achieve lowest network latency and gain some speed. Hope this helps!