问PowerBI连接到Oracle客户端出现错误

EN

我安装了Oracle客户端，但在尝试将Oracle数据放入PowerBI时出现错误

请协助

错误

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

​

​

这是tnsnames.ora

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

它在目录：E:\app\client\adm.user\product\12.2.0\client_1\Network\Admin中

路径包含

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

以下服务正在运行

​

​

@Littlefoot这里是连接屏幕

​

​

然后我被问到如何登录

​

​

然后我选择“数据库”

​

​