none
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

Answers

All replies

  • No, Power Query only stores one set of credentials for a given data source.

    Thanks.

    Thursday, July 28, 2016 6:05 PM
  • Maybe you can create 2 different TNSes so that you can show them as 2 different data sources?

    Or, if it's using the default port, you can specify it with & without port number to make them look like different sources. It's worth a try :)

    Thursday, July 28, 2016 6:10 PM
    Moderator
  •  If you can Direct me towards any explicit instructions on how to Do this, it would help,  and i will give it a shot!
    Thursday, July 28, 2016 7:15 PM