Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Oracle works in powerbi, but not with the gateway

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?


Community Support
Community Support

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.

Frequent Visitor

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!

Super User
Super User

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

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.

Thanks @collinq 

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




Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors