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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
sushovan93
Helper I
Helper I

Power BI Desktop Issue with Oracle connection in the New Sep 2025 release

I think there is something wrong with the Oracle connection from Power BI dekstop to Oracle with the New Sep 2025 relase. I have 2 versions on my system one with the Aug relase and One with the Sep release. and I have the same TNS configuration. the onld Aug one work fine where the new Sep relase gives me - Details: "Oracle: ORA-12154: Cannot connect to database. Cannot find alias rtmprddb in DataSources, , EZConnect.

1 ACCEPTED SOLUTION
anilgavhane
Resolver III
Resolver III

Use EZConnect Format

Instead of using just the alias (rtmprddb), try:

 

hostname:port/service_name

 

Example:

 

myserver.example.com:1521/rtmprddb

 

Reinstall or Repair Oracle Client

  • Reinstall the Oracle Data Access Components (ODAC) or Oracle Instant Client.
  • Make sure the Sep release of Power BI can access the same Oracle client as the Aug release.

Check Registry and Paths

  • Ensure the registry entries for Oracle client are intact.
  • Compare environment variables between the two Power BI versions.

View solution in original post

9 REPLIES 9
sushovan93
Helper I
Helper I

@anilgavhane  I tried myserver.example.com:1521/rtmprddb as you suggested and it worked.

also tried other Oracle databases and they are good to connect.

Now that I'm thinking it has to be something with that particular oracle server that I need to check with my DBA team.

Thanks every one!

anilgavhane
Resolver III
Resolver III

Use EZConnect Format

Instead of using just the alias (rtmprddb), try:

 

hostname:port/service_name

 

Example:

 

myserver.example.com:1521/rtmprddb

 

Reinstall or Repair Oracle Client

  • Reinstall the Oracle Data Access Components (ODAC) or Oracle Instant Client.
  • Make sure the Sep release of Power BI can access the same Oracle client as the Aug release.

Check Registry and Paths

  • Ensure the registry entries for Oracle client are intact.
  • Compare environment variables between the two Power BI versions.

We uses OCMT [Oracle client for MS tools] updated to the newest version but the problem still there.

spiritofme
Advocate II
Advocate II

Broken for me too.

 

One of my colleagues was able to get it to work by turning off the preview feature, "Enable using Bundled Oracle Managed ODP Provider for Import Mode."

 

Unfortunately for me, my PBI Desktop is now not accepting any changes to settings. The OK goes gray and the settings do not take. Reverting to July.....

This also solved the issue for me. 

AgustSchweitz_0-1758105604050.png

 

awright19
Advocate II
Advocate II

I am having the same issues. Installing the July version fixed the problem for now.

MaikonMoro
Frequent Visitor

Hello,

 

I had the same problem as you, the 2025 september update broke the oracle connection.

 

I fixed it installing a older version of power BI (july 2025), I downloaded it from this link (uninstall powerBi first)

https://download.microsoft.com/download/8/8/0/880BCA75-79DD-466A-927D-1ABF1F5454B0/PBIDesktopSetup-2...

 

https://learn.microsoft.com/en-us/power-bi/fundamentals/desktop-latest-update-archive?tabs=powerbi-d...

Digital_Arch
New Member

I have experienced the same issue since the release of the new version of Data Gateway.  I have updated to the latest version of Gateway (did not resolve) ... upgraded the Oracle client for Microsoft Tools (did not resolve) ... in the end to work around i added the TNS_ADMIN system variable in windows to point at the location of the ORA file as follows.  Hope this helps as a temp work around until they fix it ... 

 

Click the Environment Variables button.
In the System variables section click the New button.
Enter a variable name of TNS_ADMIN then enter a variable value of the path to the TNSNAMES.ORA file ...
Click OK.

And dont forget to reboot the box

lbendlin
Super User
Super User

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors