Forum Discussion

RSPPBI's avatar
RSPPBI
Regular Visitor
8 years ago
Solved

connecting to the same oracle database with different user accounts

Hello,   I am running into a power BI issue and maybe you can tell me if there is a solution for it by using Power query. I am trying to connect to an oracle database with the name database 1 and ...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    8 years ago

    Hi RSPPBI,

     

    Does that make sense? If so , kindly mark the answer as a solution to close the case, thanks in advance.

     

    Regards,

    Frank

v-frfei-msft's avatar
v-frfei-msft
Community Support
8 years ago

Hi RSPPBI,

 

Based on my test, all the four kinds of server names could be added in the gateway. Please notice, only the gateway is installed on the same machine with Oracle, the localhost could be used.

 

Please refer to the pictures as below.

 

 

Regards,

Frank

v-frfei-msft's avatar
v-frfei-msft
Community Support
8 years ago

Hi RSPPBI,

 

Does that make sense? If so , kindly mark the answer as a solution to close the case, thanks in advance.

 

Regards,

Frank

  • PedroCCLA's avatar
    PedroCCLA
    New Member
    6 years ago

    And this is your solution?

     

    OF COURSE that Has sense, if were work with ORACLE, you will realise that you have ONE DATABASE and differents schemas ... When you have a RIGTH DATABSE SECURITY ENVIRONMENT, you must have to create different username and password for different schemas, but, POWERBI doesn't have the habilities to create different connection to same Database with different users. I request to Database Team Admin if they can create a "Unified" user and they said, NO... it is a very very weak point in PowerBI if it want run the BI race. 

    • raphbaudier's avatar
      raphbaudier
      New Member
      3 years ago

      Hi, have you finally found a solution to your problem ? I have exactly the same problem with Amazon Redshift Database where I need with same database to create 2 different data source with user1 and user 2 with 2 different credentials, each time I change it, it changes the other source, it's a nightware ! Very weak on the powerbi side ...