Oracle Refresh Error

[Anonymous]

I'm connecting to an Oracle DB and the connection has been working fine for months. The query is slow, but it has worked.

Now, it will start loading rows, and then after a couple hundred rows are loaded , it bombs out with the following error message:
    OLE DB or ODBC error: [DataSource.Error] Oracle: ORA-03114: not connected to ORACLE 

The weird thing is that it's been auto-refreshing fine in the cloud, but I can't manually refresh in my pbix file.

[Anonymous · Accepted solution]

For some reason, changing my VPN resolved this issue. I no longer received the error during manual refresh by choosing a different VPN.

[Anonymous]

@Anonymous 

Try follow this tutorial: https://blogs.solidq.com/en/businessanalytics/get-data-in-power-bi-from-oracle-database/

There is a 1 million role limitation for returning data when using DirectQuery, you can get more details in this article.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , check the connection time out setting. this seems like timeout issue.

[Anonymous]

Thank you Amit. I think you are right. Can that be done in BI Desktop or is that done on the Database side? Thank you,

zach