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

zeel801p,

Consider to add Table.Buffer function in the codes of your advanced editor to reduce the load on the database server, or kill the connection from the Oracle server side after you refresh data in Power BI Desktop.

Regards,
Lydia

  • zeel801p's avatar
    zeel801p
    Frequent Visitor
    8 years ago

    Thanks Anonymous,

     

    I was about to try the Table.Buffer method, but am now noticing that I cannot even do a refresh without PBI opening too many simultaneous connections with even one refresh. Is this just behavir on Oracle connections or is this specific to my situation?

    • 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?