Forum Discussion
Oracle - change userid
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 ...
dennisr File->Options->Data Source Settings
You can edit the credentials used to connect to the server there
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?
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.