Forum Discussion

dennisr's avatar
dennisr
Advocate II
10 years ago

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 prompted, it just connects right away without asking me for userid/password.  How do I work around this?

 

3 Replies

  • pqian's avatar
    pqian
    Microsoft Employee
    10 years ago

    dennisr File->Options->Data Source Settings

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

    • dennisr's avatar
      dennisr
      Advocate II
      10 years ago

      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's avatar
        Eric_Zhang
        Microsoft Employee
        10 years ago

        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.