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...
For some reason, changing my VPN resolved this issue. I no longer received the error during manual refresh by choosing a different VPN.
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.