Forum Discussion
Oracle Connector Leaving Open Connections
So I recently started using Power BI with our oracle server to build some reports. What I have noticed and it has caused severe issues is that when I go to refresh my data, Power BI (via "Oracle Conn...
We are trying to avoid rebooting the servers (DB server is unthinkable, PBIRS server is not recommended, but not off the table).
We found that manually refreshing, by opening the report in the PBI desktop and refreshing from there, has a different behavior and actually closes the connections as the refresh ends.
We cheched th ODAC driver from our desktops and servers and they are both running the same versoin, so it`s not a problem with the driver version.
If anyone is facing the same problem, please vote this idea to fix the bug:
https://ideas.powerbi.com/ideas/idea/?ideaid=a3059350-4a14-ed11-b5cf-281878deb618