Connect to two Oracle databases on the same server...

mk94 · ‎11-03-2022

Hi everyone

I have a Power BI report that uses a Oracle database. Now I want to add data to that report that is stored in a differen Oracle database. The databases share the same server but have different access credentials. When I go to data source settings and clear permissions like other forum entries have suggested the first connection stops working. Does anyone know a solution to this. I've been trying to tackle this issue for days.

Thanks in advance for any hint!

SHill83 · ‎04-08-2025

Hello @mk94

Did you ever find a solution to this problem as I am looking at doing the same thing?

Many Thanks

PhilipTreacy · ‎11-03-2022

Hi @mk94

When you connect, are you just specifying the server or the server/SID, or the server/Servicename ?

More info here Connect to an Oracle database with Power BI Desktop - Power BI | Microsoft Learn

regards

Phil

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

Blog :: YouTube Channel :: Connect on Linkedin

Proud to be a Super User!