kohera-logo-regular.svg

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.

 

DSC_1388
Aggregaties
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...
blog-2303
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...
featured-2302
How to easily parse JSON in Power BI Desktop
Sometimes you want to use JSON data in Power BI. And sometimes Power BI doesn’t exactly do what you want...
header-2301
Power BI reports as monitoring tool
Who has not created monitoring reports or beautiful dashboards in Power BI? Would it not be great to show off...
your-modernization-journey-starts-now-header
Your Modernization Journey starts now
Recently Microsoft introduced SQL server 2022. We wrote this post to make sure you won’t be missing out on all...