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