Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
IP address in HOST.
I have created serveral conections to different Oracle databases using this connection method without issue
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?
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!