On-premises data gateway in-depth

Note

We recently revised the on-premises data gateway docs. We split them into content that's specific to Power BI and general content that applies to all services that the gateway supports. You're currently in the Power BI content. To provide feedback on this article, or the overall gateway docs experience, scroll to the bottom of the article.

We moved the information from this article to several articles across the Power BI and general docs. Follow the links under each heading to find the relevant content.

How the gateway works

See On-premises data gateway architecture.

List of available data source types

See Manage data sources.

Authentication to on-premises data sources

See Authentication to on-premises data sources.

Authentication to a live Analysis Services data source

See Authentication to a live Analysis Services data source.

Role-based security

See Role-based security.

Row-level security

See Row-level security.

What about Azure Active Directory?

See Azure Active Directory.

How do I tell what my UPN is?

See How do I tell what my UPN is?.

Map user names for Analysis Services data sources

See Map user names for Analysis Services data sources.

Synchronize an on-premises Active Directory with Azure Active Directory

See Synchronize an on-premises Active Directory with Azure Active Directory.

What to do next?

See the articles on data sources:

Manage data sources Manage your data source - Analysis Services
Manage your data source - SAP HANA
Manage your data source - SQL Server
Manage your data source - Oracle
Manage your data source - Import/Scheduled refresh

Where things can go wrong

See Troubleshoot the on-premises data gateway and Troubleshoot gateways - Power BI.

Sign in account

See Sign in account.

Windows Service account

See Change the on-premises data gateway service account.

Ports

See Ports.

Forcing HTTPS communication with Azure Service Bus

See Force HTTPS communication with Azure Service Bus.

Support for TLS 1.2

See TLS 1.2 for gateway traffic.

How to restart the gateway

See Restart a gateway.

Next steps

What is the on-premises data gateway?

More questions? Try the Power BI Community