Forum Discussion
RSPPBI
8 years agoRegular Visitor
connecting to the same oracle database with different user accounts
Hello, I am running into a power BI issue and maybe you can tell me if there is a solution for it by using Power query. I am trying to connect to an oracle database with the name database 1 and ...
- 8 years ago
Hi RSPPBI,
Does that make sense? If so , kindly mark the answer as a solution to close the case, thanks in advance.
Regards,
Frank
v-frfei-msft
8 years agoCommunity Support
Hi RSPPBI,
Based on my test, we can use different server names to connect to the same Oracle database using different usernames. So In your scenario, you can use four kinds of server names to meet your requirement. Here I make a test using IP address, servername and FQDN.
Regards,
Frank