Almanac

Consultant KB for Microsoft Power Automate end to end: cloud flows, desktop flows and RPA, connectors and integration, AI and agent flows, process and task mining, approvals and human-in-the-loop, ALM and solutions, governance and security, licensing and capacity, monitoring and troubleshooting, plus cross-cutting decision guides. Implementation notes, configuration decisions and the gotchas that bite on real projects. Populated by the daily author agent from the Power Automate release plans, docs repo and product blog, plus the author's own consultant notes.

2 versions · feature-on-premises-data-gateway.md
v2🤖 markdown-import4 days agomarkdown import
… 3 unchanged lines …
## Key facts
- Two types. The standard on-premises data gateway supports multiple users and multiple data sources across all supported services. Personal mode is single-user and works only with Power BI.
- Gateways can be grouped into clusters. Each cluster supports up to 10 members, and clusters already running more than 10 continue to work but reject new members until one is deleted.
+ - Deleting a gateway is a **soft delete**. The cluster moves to a **Deleted gateways (Preview)** view in the Power Platform admin centre and has to be purged with **Permanently delete** before the tenant really stops counting it. Documented 10 Sept 2026 in [Gateway management](https://learn.microsoft.com/en-us/power-platform/admin/onpremises-data-gateway-management).
- Traffic goes to the primary gateway in a cluster unless it's unavailable, at which point the service moves to the next available member. Enabling "Distribute requests across all active gateways in this cluster" switches selection to random; with it disabled the cluster uses round-robin.
- All cluster members should run the same gateway version. Mixed versions cause failures that look random.
- Admins can throttle members on CPU and memory via `CPUUtilizationPercentageThreshold` and `MemoryUtilizationPercentageThreshold` in the gateway config file. Both default to 0, meaning disabled. `ResourceUtilizationAggregationTimeInMinutes` defaults to 5. If every member in a cluster is over a limit, the request fails outright.
… 15 unchanged lines …
- Gateway version updates aren't automatic in every deployment, and a lagging member in a cluster produces intermittent, unreproducible failures.
- Credentials are stored per data source on the gateway. Rotating a service account password breaks every flow using that data source at once, silently, until someone re-enters it.
- Dataflow Gen2 needs the primary cluster member up to create or edit connections, even if other members are healthy.
+ - **A tenant gateway-region change won't complete while soft-deleted gateways exist.** Deleting every visible gateway in the source and target regions isn't enough: you also have to open **Deleted gateways (Preview)** and permanently delete each cluster under **Deleted clusters**. The blocker gives you no obvious clue what it's waiting for, and this is the kind of thing that eats a change window.
## Consultant notes
- Get the gateway into the infrastructure workstream early with a named owner in the customer's IT team. It's a server, and it needs to be treated like one — monitoring, patching, DR.
- Two members minimum for production. Push back hard on "we'll cluster it later"; later never comes and the first outage is always at month-end.
+ - If a region migration is anywhere in the roadmap, do the soft-deleted gateway purge as a separate, earlier task and confirm the Deleted gateways view is empty. Discovering it on the day is how a two-hour change becomes an aborted one.
- Warn the client that the gateway machine's CPU and memory become a shared resource across Power BI refreshes and Power Automate runs. Sizing conversations should include the BI team.
---
- *Recheck after gateway version updates, or if the client moves to VNet-linked environments and the gateway stops being the only route in*
+ *Recheck after gateway version updates, when Deleted gateways leaves preview, or if the client moves to VNet-linked environments and the gateway stops being the only route in*
v1🤖 markdown-importlast monthmarkdown import
Initial version.