Unable to connect Oracle server as source

[MSuser5]

Hi All,

I'm trying to connect Oracle server -database as source in powerBI desktop but getting below error kindly help me to fix.

Details: "Oracle: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA" 

tried below steps:

1. installed Oracle-Client-for-Microsoft-Tools-64-bit

2. tnsnames,ora - updated with below details:

Example:

TestDB =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = serverIP given)(PORT = ****))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = databsename given)

    )

  )

But still i'm getting error kindly assist what else i need to check.

Thanks,

MS

[lbendlin]

Can you use that connection with SQL*Plus, TOAD, or dBeaver?

[MSuser5]

@lbendlin ,

we dont have access for other utilities like above mentioned tools.

As per company norm need to connect directly oracle server. May i know how to fix other than this solution.

Thanks,

MS

[lbendlin]

You can do a tnc or telnet against port 1533 but that would only give you half the confirmation.