Gateway connection to Oracle (TNS:listener error)

GilbertQ and v-xicai ,

According to both of the links you have provided I should be selecting a "Direct Connect" checkbox to make sure this is not available. It looks like this is a Power BI Desktop  option only, and not available in the gatway configuration.

I still think there is a good posibility that the system user is not looking at the correct tnsnames.ora file, this was something that happened in the past, but I can't confirm this. Is there any way to confirm what file is being used by the gateway?

UPDATE 1:
I changed the service settings on the Gateway to use my Domain account, originaly configured with the default NT SERVICE/ PBIEgwService. This way the gateway app should pick up on the same TNS file I used, now the connection appears to work.

UNDERLINING CAUSE:

My best guess in my case is that because we use an Enviromental variable for TNS_ADMIN to point to a network drive which contains TNS Listener.  The default service account either was refferancing a different file, I cound not locate and edit, or permissions to that share was blocked when that account was used. Running the service under a "User" account allowed permissions and variable to be set.

Full error reported after error connecting.