Connection to an Oracle Database

[Anonymous]

I've read a lot of threads about this specific issue but none of the solutions offered have solved it for me.

I'm trying to connect Power BI Desktop to an Oracle Database.

I installed the Oracle Client 12.1.0.2 64bit (same as Power BI).

I editted the tnsnames.ora file and added the info for the server in question.

After that I click on Get Data, select Oracle Database.

 In the "server" box I tried the following string (as suggested in another thread): 

"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<myservername>)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=<myservicename>)))"

I made sure the service_name was exactly the same as in tnsnames.ora

When I click on OK, it prompts me for my username and password.

Upon all that I get the following message: 

Details: "Oracle: ORA-12545: Connect failed because target host or object does not exist"

Any help would be appreciated.

[venal]

@Anonymous 

Please refer the link for the issue.

If you have any concerns, please let us know.

If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

[Anonymous]

Hi @Anonymous ,

Please use CMD to test if you can connect to Oracle Database:

sqlplus username/password@ip:port/servername

Please refer to this article: https://kb.informatica.com/solution/5/Pages/18751.aspx.

Hopefully works for you.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.