Forum Discussion

mk94's avatar
mk94
Frequent Visitor
3 years ago

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

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!