Forum Discussion
On-premises gateway ability to limit data source connections/disable parallel loading?
I ended up writing a proxy server that accepts all of the gateway ODBC connections then brokers out the real connections to the ODBC server within the allowed license count. Works great.
I ended up writing a proxy server that accepts all of the gateway ODBC connections then brokers out the real connections to the ODBC server within the allowed license count. Works great.
Helper IIn case you're interested
There is an update now from June19 that allows you to control this on the gateway via a configuration
https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-performance-cpu
You can change the setting MashupDefaultPoolContainerMaxCount
From the linked article:
Most queries use mashup containers to execute. So the number of mashup containers determines the number of queries that can be executed in parallel. A working set defines the memory allocated to each container. These settings are available in \Program Files\On-premises data gateway\Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config.