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
9 years ago

zeel801p,

 

To force Power BI gateway to flush out its connections after refreshing, you would need to periodically run a similar script suggested by brendan_w in the following thread to restart gateway.

 

http://community.powerbi.com/t5/Integrations-with-Files-and/Possible-BUG-Power-BI-Personal-Gateway-Does-not-close-Database/m-p/76767

Replace GWConfig.exe with EnterpriseGatewayConfigurator.exe in the script that brendan_w provides , and the EnterpriseGatewayConfigurator.exe locates in C:\Program Files\On-premises data gateway.

 

Regards,

Lydia Zhang

 

 

  • zeel801p's avatar
    zeel801p
    Frequent Visitor
    9 years ago

    Thanks for the suggestion, is there any way to apply this to PowerBI Desktop. We do not currently have the gateway setup because of some firewall (and the flushing) issue and your advice will be helpful for down the road. But currently we are just having this issue when we click refresh on the desktop application. 

     

    Edit: I also noticed that once I close out of the desktop application, the connection still continues to remain open.