Forum Discussion

rsmhema1993's avatar
rsmhema1993
Frequent Visitor
9 years ago
Solved

Oracle DB credentials duration

Hai all,     When i was connected to the oracle DB, I entered my DB credentials once then when i opened it for the another time to see my report, it won't ask me to enter my login credentials agai...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi rsmhema1993,

     

    In Power BI desktop, when we first time connect to Oracle database, entered credential will be stored. You can delete credential or edit credential from Data Source Settings via File -> Options and settings -> Data source settings.

     

     

    Best Regards,
    Qiuyun Yu

     

     

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi rsmhema1993,

 

In Power BI desktop, when we first time connect to Oracle database, entered credential will be stored. You can delete credential or edit credential from Data Source Settings via File -> Options and settings -> Data source settings.

 

 

Best Regards,
Qiuyun Yu

 

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

I'm stuck on a POC to bring power bi premium (a node) into my company.  I'm using the ez connect strings and I have two user accounts I need to use.  One for an ODS and another.  Similar to this question, I get how I can change it, but becuase the ez connect string is the same I never really have the option to have both at the same time.  Does that make sense?  It assumes the current one.  

 

Is there any syntax I can add that power bi will ignore and still connect successfully so that for my purposes I have 2 distinct strings with 2 users?  

 

This is the workaround for my power bi desktop not being able to use an existing tnsnames.ora file that's saved in a super user account on my laptop. My PLSQL developer uses that one without issue.   I reviewed many posts and haven't figured out how to point Power BI to that tsnames file.  So a link to a more specific blog on this could be helpful too.  Much appreciated...