Forum Discussion
mk94
3 years agoFrequent Visitor
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!
2 Replies
- PhilipTreacySuper User
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