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
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?
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?
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!