Forum Discussion
Jairal
3 years agoFrequent Visitor
How can I enable one time log in credentials upon refresh of power queries?
I have multiple queries with access database. The access database has further connection with oracle database. When i refresh all queries, I have received multiple prompts to enter my oracle database...
lbendlin
Super User
3 years agoConnect from Power BI directly to the Oracle database?
Jairal
3 years agoFrequent Visitor
Thanks for your response. Actually, I had this established such sort of indirect connection due to unable to connect directly with Oracle database. The error message is ODBC driver related. Which is so strange, i have checked everything and ODBC driver is installed properly. Its surprising for me as i can connect MS acess to Oracle database but not excel. If this is the only solution, I will then have to raise a question to resolve silly ODBC driver error message.