Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
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.
Solved! Go to Solution.
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
Check Registry and Paths
@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!
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
Check Registry and Paths
We uses OCMT [Oracle client for MS tools] updated to the newest version but the problem still there.
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.
I am having the same issues. Installing the July version fixed the problem for now.
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)
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
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 .
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.