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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. 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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.