This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
The on-premises data gateway has settings that control resource usage on the machine where the gateway is installed. By default, gateway releases starting in June 2019 (3000.6.204) automatically scale these settings, using more or less resources depending on CPU capacity:
| Setting | Description |
|---|---|
MashupDefaultPoolContainerMaxCount |
Maximum container count for Power BI refresh, Azure Analysis Services, and others. |
MashupDefaultPoolContainerMaxWorkingSetInMB |
Maximum working set size for Power BI refresh, Azure Analysis Services, and others. |
MashupDQPoolContainerMaxCount |
Maximum container count for Power BI Direct Query. |
MashupTestConnectionPoolContainerMaxInstanceCount |
Maximum container count for test connections. |
MashupAzureConnectorsCachingPoolContainerMaxCount |
Maximum container count for LogicApps, Power Apps, and Power Automate. |
PowerQueryOnlineCachingPoolContainerMaxCount |
Maximum container count for Power Query Online. |
Use the MashupDefaultPoolContainerMaxWorkingSetInMB setting to change the default pool. Changing the memory set is only possible for the default pool. For the other pools, it isn't possible due to performance and stability reasons. The MashupDQPoolContainerMaxWorkingSetInMB settings can't be changed in the config.
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.
If you've changed any of these settings manually, for these settings to take effect you must also disable automatic scaling by setting MashupDisableContainerAutoConfig to True in \Program Files\On-premises data gateway\Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config. If MashupDisableContainerAutoConfig is set to False, automatic scaling is always enabled.
Training
Module
Manage semantic models in Power BI - Training
With Microsoft Power BI, you can use a single semantic model to build many reports. Reduce your administrative overhead even more with scheduled semantic model refreshes and resolving connectivity errors.
Documentation
Describes how to troubleshoot out of disk space errors caused by gateway spooling and persistent cache filling up all disk space.
Configure log files for the on-premises data gateway
Describes how to configure gateway log retention for various versions of the on-premise data gateway.
Plan, scale, and maintain a business-critical gateway solution
Learn how to plan, scale, and maintain gateways and gateway clusters that are deployed in business-critical scenarios.