Connect to two Oracle databases on the same server, but with different access credentials

[mk94]

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]

Hello @mk94 

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

Many Thanks

[PhilipTreacy]

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