Connection error to an Oracle XE database - TNS:could not resolve the connect identifier specified

Hi,

on my 64-bit machine I've installed the Oracle client/ODAC software and the Oracle Express Edition database (vers. 18c).

Using the SQL Developer I can connect to the XE cdb and the XEPDB1 pdv. Inside the XEPDB1 pdb I've created a new user/schema with some tables; inside Power Query I need to connect to this new user of XEPDB1.

Well, in PQ I've created successfully an Oracle connection to the XE cdb using SYSTEM as an user; in the tnsnames.ora file of the Oracle XE installation I've these settings:

Moreover, in PQ I've tried to create another Oracle connection to the new user/schema of the XEPDB1 pdb obtaining this error message: ORA-12154: TNS:could not resolve the connect identifier specified; in the tnsnames.ora file I've these settings:

new_user =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = xxx.xxx.local)
(PORT = 1521)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = new_user)
)

I can connect with the new user inside SQL Developer and for creating an ODBC 64-bit data source.

So, it seems that the Oracle client is installed rightly and Power BI recognizes it, but an error occurs for the new user.

Now, any suggests to me in order to solve this issue, please?

Has the new user to have some particular high permissions for the XEPDB1 database?

Many thanks