Forum Discussion
Oracle Refresh Error
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.
4 Replies
Anonymous , check the connection time out setting. this seems like timeout issue.
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.
