Oracle DB credentials duration

[rsmhema1993]

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 again. 

What if i change my oracle password or some error with the credentials details in first attempt? How can i get database credentials screen for the second time in power bi desktop if i need that?

[v-qiuyu-msft · Accepted solution]

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]

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... 

[rsmhema1993]

hi @v-qiuyu-msft ,

Thanks for your solution. Now i can able to get that credentials screen for the second time login.