Oracle - change userid

[dennisr]

In PowerBI Desktop, I did a "get data" and set up a connection to Oracle Server.  Now I want to "get data" for another database/user on the same Oracle server.  But when I enter the Server name when prompted, it just connects right away without asking me for userid/password.  How do I work around this?

[pqian]

@dennisr File->Options->Data Source Settings

You can edit the credentials used to connect to the server there

[dennisr]

Yes, I saw that, but didn't see a way to save new names.  The Data Source name is the Server name, and thus the last one configured remains in force (even though any prior created reports don't seem to be affected).  So, it's usable, but it would be nice if if allowed changing the name of the source.

As a short term workaround, is there a configuration file that storres the Data Source info that could be manually edited?

[Eric_Zhang]

@dennisr

AFAIK, there's no straightforward approach.

However you could create two ODBC data source if individual credentials do make sense to you. The below dsns link to the same oracle server but with differenct credentials.