Forum Discussion

zeel801p's avatar
zeel801p
Frequent Visitor
8 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

Anonymous

 

Yeah this helps in pushing a bunch of connections at the same time but the issue with not flushing properly still persists, now on two completly different Red Hat Oracle servers. 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

zeel801p,

I haven't found any methods in Power BI Desktop that can be used to flush connections. Please try to kill these connections from your server side. And for those old tables that don't need to be refreshed, disable "Include in report refresh " option in Query Editor of Power BI Desktop.



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

    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

    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