Forum Discussion

Jairal's avatar
Jairal
Frequent Visitor
3 years ago

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 credentials. This is very time taking and also fails the download if credentials are entered incorrectly in even any one of the prompt. I have already entered my database credentials in data source settings(Get Data) but still on refresh power query raise multiple prompts for log in details. Please advise on how can I enable single sign in to refresh all my queries. Thank you.

Need Help

2 Replies

    • Jairal's avatar
      Jairal
      Frequent Visitor
      3 years ago

      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.