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?
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
Watch Session 24 of Ted's Dev Camp along with past sessions!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.