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
Anonymous's avatar
Anonymous
Not applicable
8 years ago

zeel801p,

Where do you add the Table.Buffer method? Do you get any error messages when refreshing in this case?

Regards,
Lydia

zeel801p's avatar
zeel801p
Frequent Visitor
8 years ago

Anonymous

 

I did not get that far because I noticed taht it is opening too many simultaneous connections.

 

Something else I noticed is that our new AWS server is handling the connections much better then our on-prem one. It is flushing connections pretty frequently and routinly. 

 

The main issue I am having is the number of connections it opens at one time. I did read somewhere that you could disable PBI refreshing in parallel. Any chance this can be explained if it would help?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    zeel801p,

    Disable the following option in Power BI Desktop.


    Regards,
    Lydia

    • 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