CODEWITHSUNDEEP
oracle-databasepowerbipowerbi-datasource
Marium
Marium

Reputation: 253

PowerBI connecting to Oracle client gives error

I installed Oracle client, yet I get error when I attempt to get Oracle data into PowerBI

Please assist

Error

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

enter image description here

Here is tnsnames.ora

DLPOracle =
   (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = SERVER_NAME)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = service_name) 
    )
  )

It is in directory: E:\app\client\adm.user\product\12.2.0\client_1\Network\Admin

PATH contains

E:\app\client\adm.user\product\12.2.0\client_1 E:\app\client\adm.user\product\12.2.0\client_1\bin

Following service are running

enter image description here

@Littlefoot here is connection screen

enter image description here

Then I am asked how to login

enter image description here

And I select "Database"

enter image description here

Upvotes: 1

Views: 7322

Answers (1)

Marium
Marium

Reputation: 253

Put DLPOracle as server name.

Enter marium and password for credentials

Thanks to @kfinity

Upvotes: 2

Related Questions