Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
An on-premises data gateway is locally installed Windows software that connects the Power BI service to data sources in your on-premises network. The gateway uses outbound connections, so you don't need to open inbound ports to your network.
Use a gateway when the Power BI service needs to query or refresh data that it can't access directly over the internet. This article helps you choose a gateway type and find the setup and management guidance for your Power BI scenario.
If you're planning gateways for an organization, see Power BI implementation planning: Data gateways for guidance about gateway ownership, topology, availability, security, and maintenance.
For information about the gateway architecture and communication flow, see On-premises data gateway architecture.
Note
On-premises data gateway guidance is organized by scenario. This article includes guidance specific to Power BI. For guidance that applies across supported Microsoft cloud services, see the general on-premises data gateway documentation.
Types of gateways
Power BI supports three gateway options:
On-premises data gateway (standard mode): Supports centrally managed connections that multiple users can access. Use standard mode for shared data sources, DirectQuery, live connections, and high-availability gateway clusters.
On-premises data gateway (personal mode): Supports one Power BI user and can't be shared with others. Use personal mode to refresh your own import semantic models when you don't need centrally managed connections or gateway administrators.
Virtual network (VNet) data gateway: Connects Power BI to data sources secured in a virtual network. This gateway is a Microsoft-managed service and doesn't require a local installation.
Use a gateway
To use an on-premises data gateway with Power BI:
- Download and install the gateway on a local computer.
- Configure the gateway based on your firewall and other network requirements.
- Add and manage gateway connections in the Power BI service.
- Configure refresh through a gateway.
- Troubleshoot Power BI gateway issues.
Related content
- More questions? Try the Power BI Community