Oracle works in powerbi, but not with the gateway

[justinbouchard]

Hi everyone,

I'm stumped on this one. I have a on-premise gateway installed on my laptop and everything works as it should. The problem is that its a laptop and not meant to be on all the time. 

I found an old desktop that I can leave on so i can run the gateway at all times but for some reason I can't get it to connect to Oracle.  I have powerbi installed, oracle, and I'm able to connect via powerbi. The only thing that doesnt work is the gateway connection.

When I try to re-connect using my credentials I get the following error:

FAFSPowerBI: Oracle: ORA-12154: TNS:could not resolve the connect identifier specified

I'm able to connect or reconnect to my other data sources. Just not oracle. Any ideas?

[justinbouchard · Accepted solution]

SOLVED IT!

I forgot to come back here when i figured it out the first time, but the same problem happened just last week. Turns out I was editing the envrionment variable for the "user" instead of the system. Gateway uses the System variables.

[v-xiaotang]

Hi @justinbouchard 

Thanks for reaching out to us.

Please check if this post helps, Error - Oracle: ORA-12154: TNS - Microsoft Power BI Community

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[justinbouchard]

Spoke too soon! While I was able to connect Oracle to ODS through the gateway through a server/db path, I was not able to hook it up to any of my reports because tehy specified the db sever on its own!

[collinq]

Hey @justinbouchard ,

I found this thread that might be helpful - there is two or three options in there for this message:

Error - Oracle: ORA-12154: TNS - Microsoft Power BI Community

[justinbouchard]

Thanks @collinq 

Putting in the Server/DB worked for me!  I was just putting in the DB in the server name.