# Power BI Data Gateway Checklist

> Securely shuttling data to cloud tools & systems from on-premises sources, or traversing private networks.

- URL: https://data-goblins.com/gateway-checklist
- Author: Kurt Buhler
- Published: 2023-12-13
- Topic: Admin and governance

# POWER BI ON-PREMISES DATA GATEWAY

*Securely shuttling data to cloud tools & systems from on-premises sources, or traversing private networks. This checklist does not cover Personal Gateways, which generally are viewed as a Governance risk.*

---

[BACK TO OTHER CHECKLISTS](/checklists)

---

### Goblin tip:

There are three different types of data gateways:

**On-premises data gateway (standard mode):** The standard mode gateway is the most common type that you use for most scenarios. You should install a standard mode gateway on an always-on virtual machine (VM) that's dedicated for that gateway. You combine multiple standard mode gateways in high-availability clusters, to ensure that if one goes offline or is being updated, you can still use a gateway.

**On-premises data gateway (personal mode):** The personal mode gateway is installed and managed on a user machine. It's notoriously difficult to govern and manage. You should only use a personal gateway in very limited scenarios, opting instead for a standard mode gateway.

**VNet data gateway:** A VNet data gateway is a managed Microsoft service available for Fabric capacities. You use a VNet gateway for data sources on a private network or behind a firewall, like those that are on an Azure VNet. Private network data sources are becoming much more common, so you should know what a VNet and a VNet gateway are, and when/why you'd use them.

The current version of this checklist focuses upon On-premises data gateways.

![Data gateways for Power BI infographic comparing gateway types and when needed](https://images.data-goblins.blog/2026/squarespace-pages/gateway-gateway-checklist-banner.png)

## DATA GOBLINS POWER BI DATA GATEWAY CHECKLIST

**Version X.X - Update-in-progress: March 2024**

If you are setting up a Data Gateway for the first time, or auditing an existing one, the below checklist helps you figure out what to consider:

**Click the question mark (?) for a link to a reference document.** This will be learn.microsoft.com documentation; if none are available, this may be a Data Goblins article, or another blog post reference.

### Installation

Data Gateway basic installation & configuration; this is always done.

<label class="checklist-item">
<input type="checkbox" id="gateway-checklist-installation-0" class="checklist-checkbox">
Installed a Enterprise/Virtual network Gateway and not a Personal Gateway (personal mode)? <a href="#footnotes">[1]</a> <a href="https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem#types-of-gateways" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="gateway-checklist-installation-1" class="checklist-checkbox">
Installed in proximity to / on the same subnet & AD env. as the on-prem source? <a href="https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-install" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="gateway-checklist-installation-2" class="checklist-checkbox">
On an always-on virtual machine (VM) that is not a domain controller? <a href="https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-install" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="gateway-checklist-installation-3" class="checklist-checkbox">
The VM has a wired network connection (Ethernet) <a href="https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-install" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="gateway-checklist-installation-4" class="checklist-checkbox">
The VM has a SSD for Spool Storage <a href="#footnotes">[2]</a> <a href="https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-configure-disk-space" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="gateway-checklist-installation-5" class="checklist-checkbox">
Recovery keys are safely stored in a safe location accessible by multiple team members <a href="https://learn.microsoft.com/en-us/power-bi/guidance/whitepaper-powerbi-security#power-bi-security-questions-and-answers:~:text=how%20are%20recovery%20keys%20used%20and%20where%20are%20they%20stored%3F" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="gateway-checklist-installation-6" class="checklist-checkbox">
Have you adequately sized your Data Gateway? <a href="https://learn.microsoft.com/en-us/power-bi/guidance/gateway-onprem-sizing" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="gateway-checklist-installation-7" class="checklist-checkbox">
Have multiple gateways been installed & configured to a cluster (no single point of failure)? <a href="#footnotes">[3]</a> <a href="https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-high-availability-clusters" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="gateway-checklist-installation-8" class="checklist-checkbox">
Were separate Gateway clusters configured for Dev/Test and Production workloads? <a href="#footnotes">[4]</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="gateway-checklist-installation-9" class="checklist-checkbox">
Were separate Gateway clusters configured for separate tenants? <a href="https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-deployment-guidance" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="gateway-checklist-installation-10" class="checklist-checkbox">
(Virtual Network Gateways) Decide whether you need to configure Azure ExpressRoute <a href="https://learn.microsoft.com/en-us/power-bi/guidance/gateway-onprem-sizing#connectivity" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

### Basic Setup

Initial configuration & optimization steps to consider after installing the Data Gateway.

<label class="checklist-item">
<input type="checkbox" id="gateway-checklist-basic-setup-0" class="checklist-checkbox">
Ensure the gateway is in the same region as your tenant <a href="https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-data-region" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="gateway-checklist-basic-setup-1" class="checklist-checkbox">
(Proxy Server) Have you configured the Proxy Settings correctly? <a href="https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-proxy-setup-guide" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="gateway-checklist-basic-setup-2" class="checklist-checkbox">
Have you checked if you need to change the service account in the Data Gateway app? <a href="https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-service-account" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="gateway-checklist-basic-setup-3" class="checklist-checkbox">
Is the anchor gateway been configured? Do you know which gateway is the anchor in the cluster? <a href="https://www.youtube.com/watch?v=sPFRLy6XL1s" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="gateway-checklist-basic-setup-4" class="checklist-checkbox">
Are load balancing & leverage request distribution configured, appropriately? <a href="#footnotes">[5]</a> <a href="https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-high-availability-clusters#load-balance-across-gateways-in-a-cluster" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="gateway-checklist-basic-setup-5" class="checklist-checkbox">
Decide whether you need to set the Azure Relay to something other than default <a href="https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-azure-relay" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="gateway-checklist-basic-setup-6" class="checklist-checkbox">
Decide how to use & manage Data Gateway security roles (Access Management) <a href="https://learn.microsoft.com/en-us/data-integration/gateway/manage-security-roles" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="gateway-checklist-basic-setup-7" class="checklist-checkbox">
Create an access management process for new data sources <a href="https://learn.microsoft.com/en-us/data-integration/gateway/manage-security-roles" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="gateway-checklist-basic-setup-8" class="checklist-checkbox">
Know how to address common errors & port/proxy issues <a href="https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-proxy-setup-guide" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="gateway-checklist-basic-setup-9" class="checklist-checkbox">
Know the difference between data spooling & streaming with Gateways <a href="https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-configure-disk-space#gateway-spooling-data" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="gateway-checklist-basic-setup-10" class="checklist-checkbox">
Configure the log files to what you need to monitor the Gateway <a href="https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-log-files" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="gateway-checklist-basic-setup-11" class="checklist-checkbox">
Adjust performance based on server CPU <a href="https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-performance-cpu" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="gateway-checklist-basic-setup-12" class="checklist-checkbox">
Know when to scale up/out the Gateway cluster <a href="https://learn.microsoft.com/en-us/data-integration/gateway/plan-scale-maintain" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

### Governance & Security

Considerations for governing & securing the data gateway in your organization.

<label class="checklist-item">
<input type="checkbox" id="gateway-checklist-governance-security-0" class="checklist-checkbox">
Read the Power BI Security Whitepaper <a href="https://learn.microsoft.com/en-us/power-bi/guidance/whitepaper-powerbi-security#power-bi-security-questions-and-answers" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="gateway-checklist-governance-security-1" class="checklist-checkbox">
Govern/Whitelist Personal Gateways for specific trusted Azure AD Security Groups <a href="https://www.youtube.com/watch?v=VC9XoDaAE-Y" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="gateway-checklist-governance-security-2" class="checklist-checkbox">
Ingest Gateway Log files in an actionable, pro-active monitoring solution
</label>

<label class="checklist-item">
<input type="checkbox" id="gateway-checklist-governance-security-3" class="checklist-checkbox">
Set up a process & SPOC to update (monthly) or restart Data Gateways (if necessary) <a href="https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-update" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

<label class="checklist-item">
<input type="checkbox" id="gateway-checklist-governance-security-4" class="checklist-checkbox">
Set up a process to update Development/Test Gateways before Production Gateways <a href="#footnotes">[6]</a> <a href="https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-update" target="_blank" rel="noopener" aria-label="Reference">?</a>
</label>

## DATA GATEWAY DOCUMENTATION CHECKLIST

Documentation for Data Gateways should mostly be focused on the process & way-of-working; it should be connected to the team's overall DataOps methodology. A Data Gateway brings no value if the team, for example, deploys directly to Production for "hot fixes".

### Data Gateway Documentation

<label class="checklist-item">
<input type="checkbox" id="gateway-checklist-data-gateway-documentation-0" class="checklist-checkbox">
Basic info: Names, IDs (for API use), SPOC, Machine ID, Scope, etc.
</label>

<label class="checklist-item">
<input type="checkbox" id="gateway-checklist-data-gateway-documentation-1" class="checklist-checkbox">
Last updated / restarted
</label>

<label class="checklist-item">
<input type="checkbox" id="gateway-checklist-data-gateway-documentation-2" class="checklist-checkbox">
Any advanced or custom config. settings (i.e. ExpressRoute, Azure Relay, Proxy settings...)
</label>

<label class="checklist-item">
<input type="checkbox" id="gateway-checklist-data-gateway-documentation-3" class="checklist-checkbox">
Roles, data sources & how they are managed
</label>

<label class="checklist-item">
<input type="checkbox" id="gateway-checklist-data-gateway-documentation-4" class="checklist-checkbox">
The process for how a new data source is requested/added
</label>

<label class="checklist-item">
<input type="checkbox" id="gateway-checklist-data-gateway-documentation-5" class="checklist-checkbox">
Recovery Keys
</label>

<h2 id="footnotes">FOOTNOTES</h2>

[1] There are 3 types of on-premises data gateways:  
1. Enterprise Gateway: For on premises data sources  
2. Virtual Network Gateway: For traversing private networks  
3. Personal Gateway: For small-scale, personal BI usage scenarios.  
*See the linked article in the checklist for more info.*

[2] Spool storage will transiently store data on the Gateway machine. With an SSD this goes faster than a classical HDD. Check the linked article for more details.

[3] In smaller-scale situations, you might not need a cluster; however, avoiding the single point of failure plus load balancing is a huge advantage. It is generally worth it to set up a Gateway cluster.

[4] This is to ensure that queries from Development & Test workspaces do not interrupt Production workloads causing latency issues for business user queries.

[5] Load balancing ensures that if one Gateway is experiencing a high load, another will be used. You can adjust the thresholds for which this happens, yourself.

[6] Rarely, Gateway updates can cause issues with existing queries. It is thus a good practice to first update on your Development and Test Gateways to avoid situations where an update causes an outage in Production workloads.
