Forum Discussion

pabeader's avatar
pabeader
Post Patron
6 years ago

Oracle database refresh never finishes.

I have a sucessful connection to an Oracle database.  I even have a query under the advanced option to limit the incoming number of rows. I have let it sit for hours and the refresh never completes....
Need Help
v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi pabeader ,

 

Could you please verify if you have the correct version of Oracle Client installed, such as 64-bit Client with 64-bit Power BI Desktop, please also check the version requirement:

 

Supported Oracle versions:

  • Oracle 9 and later
  • Oracle client software 8.1.7 and later

 

If the duration time of import is very long, could you please try verify the connection to oracle server by using DirectQuery mode?

 

Please refer to this document: https://docs.microsoft.com/en-us/power-bi/desktop-connect-oracle-database


Best regards,

 

pabeader's avatar
pabeader
Post Patron
6 years ago

Both are 64-bit

Oracle 12c

Driver 121024

Download version of Power BI since the Marketplace version still doen't work with Oracle.

 

If I set it to Directquery it never connects.  (Waited almost 1 hour)

 

 

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi pabeader ,

     

    Does this connection issue also happened when using other official tools to connect this Oracle Database? Have you assign sql statement when you tried to use DirectQuery last time? Could you please try to increase the value of timeout in Oracle.Database fuction?

     

    Oracle.Database(server as text, [CommandTimeout=#duration(0,1,0,0), ConnectionTimeout#duration(0,1,0,0)])


    Best regards,


     

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    Hi pabeader ,

     

    How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?


    Best regards,

    • pabeader's avatar
      pabeader
      Post Patron
      6 years ago

      I have develpoded a new issue.  I am getting an error when I try to connect.

      Details: "Oracle: ORA-12638: Credential retrieval failed"

       

      I have tried the only answer I have been able to find which is:

      SQLNET.AUTHENTICATION_SERVICES= (NONE)

       

      That has not helped.