How to set the maximum number of connections a gateway can have to a single source?

[Anonymous]

I have a PostgreSQL database as a datasource, and a PBI report with 16 tables. I would like to refresh tha dataset through an on-premises gateway, but it always fails with SQL 53300 too many requests. It is actually caused by the gateway as it opens endless number of connections to the server, until it reaches the limit, and the next connection fails. What I tried are the following:

1. Disable parallel loading based on this: https://community.powerbi.com/t5/Desktop/Power-BI-Desktop-automatic-refresh-queries-one-by-one/td-p/...
2. Limit the MashupDefaultPoolContainerMaxCount to 1 based on this: https://community.powerbi.com/t5/Integrations-with-Files-and/On-premises-gateway-ability-to-limit-da...
3. I found the following settings in the same file as in the 2. option: DbConnectionPoolMinSize, DbConnectionPoolMaxSize and DbConnectionStatefulPoolMaxSize which were 128 for min and 256 for max count, so I reduced them to 1 and 32 respectively.

What other options can be, how can I achieve a normal connection count? Where are those options for the gateway documented?

[v-chuncz-msft]

@Anonymous,

Also check if Timeout parameter in Advanced Editor helps.

[Anonymous]

Hello @v-chuncz-msft,

That is about the timeout regarding no answer from the server for the connection request, but the server answers correctly, it is declining the request due to too many other connections. I do not see how this option prevents opening too much connections in the first place. Could you explain a bit more?

Br,

Szabolcs