Power BI – Gateways to heaven

Although the Power BI gateways have been around for some time now, they weren’t really easy to use. Depending on what you needed to do – refresh your data from the Power BI or use the live connection method – you had to install a different gateway.

In the past you had two different gateways:

  1. Personal Gateway, which was used to refresh datasets that were published to the PowerBI.com environment
  2. Enterprise Gateway, which made it possible to work with live connections on premise data sources


Next to the annoyance of having to install two separate software packages for your Power BI cloud solution, you would think there is no real issue. Wouldn’t it be for the fact that you can’t install both packages on the same machine. So if you would need to refresh data and have live connections in one environment, at least two different machines on-premise are required to make this work: one to install the personal gateway, and the other to install the enterprise gateway.

The general idea was that at some point in time these two gateways would both come together in the Enterprise Gateway. That finally happened in July this year. After launching the Enterprise Gateway in February 2016, Microsoft announced the new Enterprise Gateway that combines both packages at the beginning of July. As part of the announcement, Microsoft also changed the name of the Enterprise Gateway to On-premises data gateway. This means that now we only need to install one software package on one on-premise machine to get a connection between PowerBI.com and on premise data sources. You can then setup one or several connections, depending on your setup.


The new on-premises data gateway has more to offer. It behaves as a bridge and connects not only Power BI but also allows a secure data transfer between on-premise data and the Power BI, PowerApps services, Microsoft Flow and others. This means a big step forward for connecting Power BI with on-premise systems. The new data gateway also opens doors to the future to not only be limited to PowerBI.com, but also giving connection possibilities to other applications.


Database specific security in SQL Server
There are many different ways to secure your database. In this blog post we will give most of them a...
SQL Server security on server level
In this blog, we’re going to look at the options we have for server level security. In SQL Server we...
Microsoft SQL Server history
Since its inception in 1989, Microsoft SQL Server is a critical component of many organizations' data infrastructure. As data has...
Power BI Desktop is een prachtige tool om snel data-analyses te kunnen uitvoeren. Je connecteert op een databron, importeert en...
dba image
DBA is not that scary
Often when talking to people who are looking for a career path in the data world I feel like there...
How do you link an SCD Type 2 table in Power Query?
This article uses a simple example to demonstrate how to link an SCD Type 2 table in Power Query to...