Keep your dashboards & reports with on-premises data up to date

With Power BI gateways, you can keep your data fresh by connecting to on-premises data sources. Query large data sets while leveraging your existing investments. The gateways provide the flexibility you need to meet individual needs, and the needs of your organization.

Choose the gateway that best fits your needs

For personal use

Refresh your on-premises data quickly without waiting for an IT Admin. Designed for use with personal data sets, there is no central monitoring capabilities for this gateway.

Power BI Gateway - Personal

For enterprise deployments

This gateway is used by organizations to serve a large number of users. It also enables administrators to set up access control for individual data sources and monitor usage.

Power BI Gateway - Enterprise (preview)

PERSONAL

Learn more

ENTERPRISE

Learn more
Features
Import data and set up scheduled refresh Coming soon
Run as an app for users who aren't administrators on the computer
Run as a single user with your credentials
Serves multiple users with access control per data source
Support for DirectQuery to SQL Server
Support for a live connection to Analysis Services
Monitoring and auditing for gateway and data sources Coming soon

Analysis Services Connector

Analysis Services Connector allows you to connect, and issue live queries, to an Analysis Services Tabular server for use with Power BI dashboards and reports.

SQL Server Reporting Services 2016

With Reporting Services 2016, users can pin a visualization from a report to a dashboard in Power BI.