将Oracle DB与Power BI连接时出现错误

我正在尝试使用Power BI与Oracle 12c数据源连接，我寻找了多种解决方案，并按照Microsoft文档中的说明进行操作

https://docs.microsoft.com/zh-cn/power-bi/desktop-connect-oracle-database#installing-the-oracle-client

但是我认为工作中缺少一些东西。

• 首先尝试通过Oracle数据库进行连接：

我要在同一台笔记本电脑上安装新的Oracle和powerbi，服务器应采用文档所述的“ ServerName / SID”格式，因此我的将是：

本地主机/ testdb

然后添加数据库用户和密码

我得到这个错误

I have just installed Oracle 12c 64 bit on my laptop to test the connection

also I am using Power Bi 64 bit on also I am on windows 10 64 bit

I have also installed "64-bit Oracle Data Access Components (ODAC)" from Oracle website: http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html

where I have added my database to DSN using both "OraDB12Home1" and "OraClient12Home2"

and also for both DSN I have tested the connection and it was successful

• Next I test connecting using ODBC OraClient12Home2:

then inserting username and password for database

then I get this Error

and when I connect with OraDB12Home1 I get this error:

I have also clear all data source connections on power bi because sometime it just display the error without sending me to next screen to enter user and password

These are the details of tnsnames.ora :

  # tnsnames.ora Network Configuration File: 
  C:\app\Ahmadssb\virtual\product\12.2.0\dbhome_1\network\admin\tnsnames.ora
  # Generated by Oracle configuration tools. 

  LISTENER_TESTDB =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


TESTDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = testdb)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl.babader.com)
    )
  )

I don't know what am I missing I even have exported the data from oracle as dump file and convert it as sql but it seems like this is not supported now on power bit and this is another situation.

I need to get my database data into PowerBi the data what, am I missing and what should I do to make it connect successfully?

---

• Update: trying testdb on Server field:

as suggested on comments to change localhost/testdb to only testdb (also tested in capital TESTDB) since it should be typed on server. But this also didn't work with me and still getting the same error check the following pictures:

it seems like the connection to oracle is not working, is there something I should do in oracle to make this work?