Forum Discussion

zeel801p's avatar
zeel801p
Frequent Visitor
9 years ago

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...
Need Help
zeel801p's avatar
zeel801p
Frequent Visitor
8 years ago

Yeah no luck. As soon as I flush them they are being recreated the next refresh. And now that it is creating 30+ connections per refresh I cannot even flush it after every refresh since it does not complete a refresh.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

zeel801p,

I test the similar scenario that refresh the data from SQL Server database, as long as I click refresh button in Power BI Desktop, it will open connections in the server side. Currently, we can only kill these connections from database side after the refresh.

Regards,
Lydia

  • zeel801p's avatar
    zeel801p
    Frequent Visitor
    8 years ago

    Any idea if you guys will be fixing it or is it more realistic to just look into alternatives?

  • zeel801p's avatar
    zeel801p
    Frequent Visitor
    8 years ago

    I find it hard to believe that other Oracle users are not having issue with this many open connections. I am working on splitting my reports into several smaller reports to account for this but it is not an ideal situation. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    would be great to have a resolution to this as it is a persistant problem