Connect on the same server alias but with a different user schema

[Anonymous]

Hello all,

When I use Power BI, I connect a report to an Oracle user schema to retrieve a view. The user schema (DB1) is located on a particular server S1. On this server there are several user schema. Now, I want to connect to another user schema (with different DB credentials) called DB2. However, when I type the server TNSName on the prompt to connect to Oracle DB, I'm automatically connected to DB1, so there is no way I can retrieve data from DB2. Grants from DB2 to DB1 is not an option. 

Can anyone know how to connect to the same Oracle server but with different user schema ? (Btw, connecting to another server is ok, but the same problem exists if I try to switch user in the second server...)

Thanks ! 

[v-cherch-msft]

Hi @Anonymous

You may have a look at below post to check if it is helpful to you. Then if you got any issue on Power BI Report Server, I would suggest you to post your question here for more professional help.

https://community.powerbi.com/t5/Desktop/connect-to-the-same-database-with-2-different-users/td-p/7539

Regards,

Cherie