Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

Reply
mcguija
Helper III
Helper III

Installed new Oracle client, now Gateway datasource no longer works.

Hi, I had been running Oracle 12c client and doing refreshes to cloud with Gateway Datasource fine for years.

Today I installed Oracle 19c client on the gateway server and tested a connection to the oracle database with SQLPlus and it connected. 

I am using the same TNSNames.ora file, copied to the new 19c directory.

 

Now my gateway datasource does not work.  I think Powerbi does not know where my tnsnames.ora file is??

 

Can someone help?

2 REPLIES 2
RossEdwards
Solution Sage
Solution Sage

I'm also an Oracle driver user both with 19c and 12c, so i'm quite familar with your pain.  19c is pretty straightforward at least, unlike the very particular installation you need with 12c where one out of order step can cause you to start again.

 

Things to check:

1. Make sure you have installed 64-Bit and not 32-Bit drivers

2. Make sure you also installed the 64-Bit ODAC.  It is a sepearate installation package.

3. Check the environment variables (System Properties -> Advanced -> Environment Variables).  In this section look at the 'System Variables' and find the "Path" entry.  Make sure the 19c 64bit Oracle driver is the highest entry compared to any other Oracle installation entry.
4. Still in the environment variables, check if you have an entry called ORACLE_HOME.  It could be pointing to the wrong home folder.  Its possible to have more than one.  Remove this entry if you want to test.  You can always put it back.

5.  Check your oracle installation path for the tnsnames.ora file.  You should find this under  "<Relevant Oracle Home Folder>"\product\19.0.0\client_x64\network\admin


I'd also recommend installing Power BI Desktop on your gateway server.  Open up a project that uses an oracle source.  This should let you troubleshoot faster as you can keep iterating until it works in Power BI Desktop.  Once it works there, it will work under normal gateway circumstances.

GilbertQ
Super User
Super User

Hi @mcguija 

 

It does appear to be that it cannot find the file you are looking for Is it possible to reinstall the previous version of the oracle client?

 





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

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.

Top Solution Authors