Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I need a connection solution for Oracle. This shouldn't be this difficult. I am trying to connec to an Oracle server and get the following:
However, the Oracle client is installed. I try to connect:
When I connect I get the following error:
Solved! Go to Solution.
Figured it out. After finding the path for the .ora file I entered the information in the file. Then in PowerBI I added the connection name from the .ora file to the connection string
where would I find the Oracle DB ip address?
I get access denied when I try to query it in sql developer.
I had the old DB admin ping it as xx.xx.x.x a few months ago before turnover and turmoil turned everything into a mess where it's not even clear if there is a DB admin anymore.
Now the error is:
Details: "Oracle: ORA-12170: TNS:Connect timeout occurred"
tnsnames.ora file is now:
du1p.company.com =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ipaddress)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = du1p.company.com)))
When Power BI asks for a "server", I tried typing in:
(1) the ip address
(2) du1p.company.com
(3) du1p
In each case, the error was:
Details: "Oracle: ORA-12170: TNS:Connect timeout occurred"
If it means anything, I can log onto the server from SQL Developer ONLY on a virtual machine.
I tried to install a local copy of SQL Developer and even imported the connection from the vm version, and i get the following error:
"An error was encountered performing the requested operation:
IO Error: The Network Adapter could not establish the connection
Vendor code 17002"
If the issue is (1) an ip mismatch issue between my PC and the data base IP, how would I go about resolving it? (first, I need help finding what the oracle ip is) or (2) a firewall issue, how would i fix the firewall issue?
You would have to troubleshoot this outside of PowerBI
starting with what?
Not sure. You would have to troubleshoot the Oracle side of things
I have the same error Details: "Oracle: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA"
and i couldn't Fix it . I am New to power BI . Can you please tell me how to fix it
How about this thread?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
120 | |
75 | |
46 | |
44 | |
35 |
User | Count |
---|---|
180 | |
85 | |
68 | |
47 | |
46 |