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 connection...
We're also seeing this issue.
The poor handling of connections also results in a failed refresh if you do a database restore of the source Postgres database. Personal Gateway has to be restarted in order to flush out its connections and reconnect successfully.
We're currently having to periodically run a variation of the suggested script (updated for Personal Gateway 2.0) to restart our gateway.
Taskkill /IM GWConfig.exe /F timeout /t 5 & "C:\Users\Administrator\AppData\Local\Power BI Gateway - Personal\2.0\Configurator\GWConfig.exe" Exit
Any permanent solution for this bug ? I see that it has been discussed since 2015.