[ #Office365 ] Power BI 2.0, part 5: the gateways

Fifth article from a series on [ #Office365 ] Power BI 2.0 :

  1. The big picture (updated with GA infos)

In an hybrid architecture like the one of Power BI, it is critical for the Cloud service to get access to on-premises data sources and moreover to be able to refresh the data. So in this post we will focus on this part of the architecture:

image

In Power BI world, data refresh from on-premises sources capability is given by the gateways. In fact you have two gateways.

  • Power BI Personal Gateway
  • Power BI Analysis Services Connector

image1. Power BI Personal Gateway

The Power BI Personal Gateway is essentially a Windows executable that can be run as a standard Windows application or as a Windows Service.

You can either run it:

  • without admin permissions as a standard application (but in this case you must be looged in to your computer at the scheduled refresh time) or
  • with admin permissions as a Windows service (in this case you need only to have the computer and the Gateway service running at the scheduled refresh time)

Once launched, it will show up in the system tray:   image

It will act as a bridge, doing scheduled refresh of your on-premises files to Power Bi Service in the Cloud.

It is NOT needed for any cloud based services.

It is NOT needed when you put your Excel or .PBIX files in OneDrive or OneDrive for business where automatic refreshes can occur.

It IS needed when your data source is on-premises. It supports:

  • Databases sources: SQL Server, Oracle, Teradata, IBM DB2, Sybase, MYSQL
  • SharePoint lists
  • Files (Excel, .csv, .xml, .txt, Access) and Folders
  • On-premises SQL Server Analysis Services Tabular models  (as uploaded data; not live connections)

Once installed you are able to query the above supported data sources via:

  • Query in a .pbix file and upload that file to the PBI service,
  • Power Query in an Excel file and upload that file to the PBI service.

Clicking on the Dataset in the browser interface gives you something like that:

image

image

Please note here that you can add up to eight refresh time per day.

image

Beyond the scene, if we go to the services.msc we can see that PBI Personal Gateway is relying on the “Data Management Gateway”:

image

2015-07-14_13h32_03

A configuration tool is even availableimage, which provides access to the following information:

2015-07-14_13h32_312015-07-14_13h32_45

2015-07-14_13h33_032015-07-14_13h33_18

2. Power BI Analysis Services Connector

PBI Analysis Services connector has a very distinct functional goal. It is designed to give access to SQL Server Analysis tabular models stored in on-premises instances from the Power BI Service.

However it’s technically very similar at the point that you can’t install both on the same computer. PBI AS Connector is also relying on a “Data Management Gateway Host Service” which is obviously a flavor of the other. Note that PBI AS Connector can only be run as a service, and is designed to run on a server rather than on a PC.

image

There are some interesting prerequisite for the AS Connector to run smoothly:

    • The Analysis Services server is domain joined.
    • The Analysis Services connector & Analysis Services server are installed on computers in the same domain.
    • If you use a .onmicrosoft.com email address, you’ll need to sync your Active Directory to Azure Active Directory using Azure Active Directory Sync (DirSync).

The complete installation process for the connector is detailed here: Configure a Power BI Analysis Services Connector. Il will bring you to such

And bring you to such views when selecting (in Power BI Service): Get data > Database & More > SQL Server Analysis Services > Connect

 

Sources :

Advertisements

3 thoughts on “[ #Office365 ] Power BI 2.0, part 5: the gateways

  1. Pingback: [ #Office365 ] Power BI 2.0, part 5: the gateways | Blog on IT

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s