Power BI Gateway

The Power BI gateway is a software (service/app) that enables you to connect from the Power BI service on the cloud to the on-premise (in-house) data sources in your company’s intranet.

There are two versions of the Power BI gateway: Personal and Enterprise (to be consumed by all users you choose in your organization).

Power BI Gateway Installation:
Install the power bi gateway from the web or from the Power BI service from the download icon, against the server you want to use to funnel your BI users to your BI data source:
image32

 

You may get different notifications:
image31

But otherwise, it is pretty straight forward:

image26

Then you need to sign in to Power BI. Click on that button.

Power BI Gateway Configuration
After installation, you need to set up the name and recovery key for the gateway. This is the key that you will use if you ever re-installed your gateway in another server:
image35

Then you are done:
image33

Power BI Gateway data sources configuration
Click “Close & Add data sources”. You will then see the screen for configuring the data source.
image38

Make sure to use the domain name before the user name, otherwise you will see this message:image30

You can return back to your data source > Go main Power BI window > Configure Icon > Manage Gateways (check above snapshot for the icon):

image39

Now you can see the users tab > Add the users that will be able to use the gateway to connect to your on-premise data sources:

If you receive this message, you will need to map your Office365 users (which are normally emails like user1) to your Active Directory users, which are usually like YourCompanyDomainuser1.
image29

You can do this mapping from the mapping button in the users tab of the gateway data source window:
image27

This is a closer look and an example of the mapping:
image28

If you decided to go move the server that hosts the gateway (say for security reasons or upgrades), you can re-install the gateway .exe file on the new gateway server, and choose “Restore Existing Gateway”:

image40

Then all you need to do is choose the gateway name from a dropdown list, and type the recovery key you first chose when you first installed your gateway in the first server:

image25

Consume the Gateway and its Data Source:
Once you install and configure your gateway and data sources, they will show in the list of data connections: you can consume them simply by choosing the data connection.

Go to the “Get Data” button on the left hand side list of your Power BI service >
image34

Choose Databases >
image41

You will see the data source of your gateway listed > Choose it:

image37

Then its data set will show on the main left-hand-side list > Click this data set and you will be able to

image36

That’s all for now!

Leave a Reply

Your email address will not be published. Required fields are marked *