Forum Discussion

MelissaSnell's avatar
MelissaSnell
Helper I
10 years ago

Possible BUG? Power BI Personal Gateway Does not close Database connections to PostGreSQL

We have about 6 datasets that are set to refresh on a schedule. This works as expected. However periodically the source PostgreSql database starts to deny connections because the number of connection...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

I've seen some similar issues posted regarding the gateway not closing connections properly to databases so likey some sort of bug.

MelissaSnell's avatar
MelissaSnell
Helper I
10 years ago

I was hoping to be able to use Task Scheduler to stop and re-start the Gateway as a service, to save me from having to re-boot the workstation once or twice a week, but can't seem to see it listed, even though I installed it as an Administrator.

 

In addition I have just installed the October 22 release of the Personal Gateway, that seems to hold some promise of solving other issues that I was getting, so am hopeful that it might address this one as well

  • MelissaSnell's avatar
    MelissaSnell
    Helper I
    10 years ago

    As a workaround I managed to get the Data Management Service installed during the Gateway installation process and now I am running a batch file using Windows Task Scheduler with a NET STOP SLEEP 120 NET START kind of thing.

     

    I am awaitng feedback from the DBA to see if this is a viable work around

    • brendan_w's avatar
      brendan_w
      Advocate I
      10 years ago

      Melissa did you have any luck with this workaround in the end? The Gateway is still leaking connections for me, so clearly this bug has not been fixed.

       

      I've tried setting the task scheduler to do a reboot but this doesn't work as Power BI doesn't recognise that the Gateway is active upon the reboot. It would be very interesting to hear about your experiences with this issue.

      • brendan_w's avatar
        brendan_w
        Advocate I
        10 years ago

        For anyone that encounters this in the future. This is the batch file i've used over the last few days to prevent the connection leaks from occuring.

         

        net stop PBIEgwService
        Taskkill /IM GWConfig.exe /F
        timeout /t 30
        net start PBIEgwService
        "C:\Users\Administrator\AppData\Local\Power BI Personal Gateway\1.0\Configurator\GWConfig.exe"
        Exit

         

         

        As well as rebooting the service it's necessary to restart GWConfig. Without this the web client doesn't recognise that a Gateway is online. It's also necessary to have a taskkill on the GWConfig to prevent multiple instances being active.