Oracle connection error: Object reference not set to an instance

Figured it out now: I kept the installation with having ODAC installed to client_1. I de-installed the store version and installed the download version. I new error related to TNS names Oracle: ORA-12541: TNS:no listener" when I connected to the computername as server name in Power BI. I checked the tnsnames.ora in C:\app\client\anitaberg\product\12.2.0\client_1\Network\Admin and then tested to log on as localhost as server name. Got then the error Details: "Oracle: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA" , then I used the name of the service (if it is called that) ORCL as server, and then Power BI was able to show the three of tables.

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