Connect to a Database with 2 separate Usernames/passwords. RRS feed

  • Question

  •  I am trying to Load data into PowerQuery from an Oracle database. The Database has 2 separate usernames/passwords for 2 different sets of Tables (Views).

     Currently I have been going into the connection properties and changing the password there, and then Loading that set of tables into the model. Then I go back to connection properties change password a second time and Load again. But then the 1st set of tables becomes disconnected ( errors etc..). this makes it difficult to go between the 2 Tables Views.

    Is there a way to duplicate this connection in a "My Connections" file or duplicate in another manner?

    Thursday, July 28, 2016 3:26 PM


All replies