Power BI Gateway Explained

    Tips & Tricks

THE POWER BI SERVICE, GATEWAY CONNECTION

To understand the Power BI Gateway, you first need to understand how Microsoft has structured its vendor hosted Power BI service (app.powerbi.com). Instead of installing application servers locally or installing an application on a server running in the cloud, Power BI service is fully managed and hosted by Microsoft on its Azure cloud stack.

This architecture means that any published report that needs access to data on your local or corporate network will need a way to securely access that information. And this is where Power BI Gateway comes in.

Power BI Gateway enables Power BI service to securely reach back into your network for data to display in Power BI service.

CONFIGURATION BEST PRACTICES

You will need to install Power BI Gateway on one or more computers on your network. In an enterprise environment, Senturus recommends setting up a development Gateway server and production Gateway server. This practice allows you to test out the monthly Gateway software updates and configure new data sources without risk to your production environment. However, these gateways will both connect to your same Power BI service.

These gateways are thought of as clusters by Microsoft. By default, you have a 1-node cluster of each gateway when you install it. You can add additional gateway machines to an existing cluster for higher redundancy and load balancing.

 

 

 

The Power BI Gateway supports both importing data on a schedule and running live queries against your local data sources, a capability Microsoft has dubbed DirectQuery. If your organization heavily uses DirectQuery, you should consider running a 2- or more-node cluster for both uptime and performance reasons.

INSTALLATION AND UPGRADING

After the Power BI Gateway software is downloaded and installed, it will run as a service. By default, it will start running under a dedicated local service account. Senturus recommends that you configure a specific domain user account for this service so that permissions can be managed by IT at a domain level, assuming you do this for other service level accounts in your organization.

The application will then walk you through logging into Power BI service to add your gateway to a new or existing cluster. We also recommend turning on the HTTPS mode on the Network tab so that your data is securely encrypted at all times. Once complete, your gateway will be online and ready for use.

DATA SOURCE SET UP AND PERMISSIONS

Data sources can now be setup in Power BI service that rely on this data source. When reports are published that reference those data sources, Power BI service will be able to securely reach back into your network for fresh data.

After navigating to the Manage gateways page in Power BI service, you will see a list of your installed clusters. You can then add data sources to each gateway cluster, supplying the data source type and authentication information. The Users tab allows for specific users or security groups to be granted access to the data source for their published reports.

DATA SOURCES SINGLE SIGN ON

The Power BI Gateway can also pass authentication information to the data sources your users will connect to. This means row level security for a user will be enforced at the data warehouse layer because that DW knows who they are. This is typically accomplished using Kerberos and is supported by a subset of Power BI data sources. If your data warehouse supports it and your team manages RLS at the data warehouse level, the end result is that users viewing reports on Power BI service will only see the slices of data they have access to. For example, a store manager would only see information about their store, but a corporate manager would see information about all stores.

POWER BI GATEWAY SUMMED UP

Power BI Gateway is a vital component in any enterprise level Power BI deployment. Considerations around dev and production environments, user accounts, VM sizing, redundancy and more need to be considered when deploying a Power BI Gateway.

SOUND DAUNTING?

If installing, configuring and optimizing Power BI sounds a bit daunting, it is. But don’t let that deter you. Senturus can help. Senturus can provide expert support when and how you need it. Contact us.

/