The on-premises data gateway acts as a bridge. It provides quick and secure data transfer between on-premises data, which is data that isn't in the cloud, and several Microsoft cloud services. These services include Power BI, Power Apps, Power Automate, Azure Analysis Services, and Azure Logic Apps.

By using a gateway, organizations can keep databases and other data sources on their on-premises networks while securely using that on-premises data in cloud services.

Why use an on-premises data gateway?

LUCS/TM databases are hosted on the SQL Server in your internal network. In order to use Microsoft cloud services such as: Power BI Embedded reporting or Power BI Paginated report your data needs to be transferred to the Microsoft Cloud.

Data gateway prerequisites

The on-premises data gateway acts as a bridge between BI and your local data. According to the Microsoft definition there are two types of gateways to install, depending on your usage scenario.

  • On-premises data gateway - Allows multiple users to connect to multiple on-premises data sources.
  • On-premises data gateway (personal mode): Allows one user to connect to data sources and can’t be shared with others.

Gateway Server

The gateway server must be hosted in the same network with SQL sever that host LUCS database, for small environments it may be hosted on the same server with SQL database.

(info) Learn more how to install the gateway server.

Minimum Gateway Server RequirementsRecommended Server Requirements

Each server must fulfill the following minimum requirements:

  • .NET Framework 4.6 (Gateway release August 2019 and earlier)
  • .NET Framework 4.7.2 (Gateway release September 2019 and later)
  • A 64-bit version of Windows 8 or a 64-bit version of Windows Server 2012 R2 with current TLS 1.2 and cipher suites
  • 4 GB disk space for performance monitoring logs (in default configuration)

For optimal performance we additionally recommend:

  • An 8-core CPU
  • 8 GB of memory
  • A 64-bit version of Windows Server 2012 R2 or later
  • Solid-state drive (SSD) storage for spooling.

Gateway account sign-in

  • You need to sign in with either a work account or a school account. This account must be an organization account. If you signed up for an Office 365 offering and didn't supply your work email address, your address might look like
  • Your account is stored within a tenant in Azure AD. In most cases, your Azure AD account’s User Principal Name (UPN) will match the Email address as provided by your Administrator.
  • The gateway is associated with your Office 365 organization account. You manage gateways from within the associated service.

BI User Pro Account

Pro-User Requirement

If you plan use a gateway for Power BI Reports when hosted in workspaces with multiuser access, your Microsoft user account requires a Power BI Pro license. This user will manage host gateway connection to your database from Power BI service side