Forum Discussion
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 connections has reached its limit.
Viewing the database logs shows that there are multiple connections open from the IP address of the Workstation that hosts the Power BI Personal Gateway.
Restarting the workstation closes the open connections.
I would expect the connections to be closed following the refresh of an individual dataset.
10 Replies
2 years later the same
I've seen some similar issues posted regarding the gateway not closing connections properly to databases so likey some sort of bug.
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
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
Any update? as it is still an issue on late 2019...
