I may have missed it but just in case consider using the HTTPS connection to encrypt your out-bound data communications. There are a lot malcontents out there that would love nothing more than to intercept your information.

By Gandhali Joshi – Before setting up a gateway, let’s understand what a gateway is and how it works. When you create Power BI reports based on on-premises data and publish them online, to refresh your datasets, you will need a way to access your on-premises data sources. This can be achieved with a data gateway.

In most cases, to share the reports you created on Power BI Desktop, you need to publish them to the Power BI service in the cloud, also known as PowerBI.com. Once this happens the mechanics of refreshing your dataset change, which means the cloud, not your machine, needs to have access to your data sources.

A gateway is a piece of software that acts as a bridge between the cloud and your on-premises data sources. With a data gateway, you can not only access your on-premises data sources but also schedule refresh for the datasets published to the Power BI service.

The Power BI Gateway can be installed in two modes

1)     On-premises data gateway:

• This gateway can be used by multiple users that have access to the server on which you install the gateway.
• It can be used for both scheduling refresh and live queries in Power BI.
• You can also use it for PowerApps, Logic Apps, and Microsoft Flow.
• This gateway is well-suited to complex scenarios with multiple people accessing multiple data sources

2)     On-premises data gateway (personal mode):

• Only you can use this, and you can use it only for scheduling refresh in Power BI.
• Allows one user to connect to sources, and can’t be shared with others.
• An on-premises data gateway (personal mode) can be used only with Power BI.
• This gateway is well-suited to scenarios where you’re the only person who creates reports, and you don’t need to share any data sources with others.
• The Live Connection connectivity mode, PowerApps, Logic Apps, Microsoft Flow are not supported.

You can install up to one gateway in each mode on the same computer, and you can manage multiple gateways from the same interface on PowerBI.com.

How the gateway works

Let’s first look at what happens when you interact with an element that is connected to an on-premises data source.

1)     The cloud service creates a query and the encrypted credentials for the on-premises data source. The query and credentials are sent to the gateway queue for processing.

2)     The gateway cloud service analyzes the query and pushes the request to Azure Service Bus.

3)     Azure Service Bus sends the pending requests to the gateway.

4)     The gateway gets the query, decrypts the credentials, and connects to one or more data sources with those credentials.

5)     The gateway sends the query to the data source to be run.

6)     The results are sent from the data source back to the gateway and then to the cloud service. The service then uses the results.

In step 6, queries like Power BI refreshes and Azure Analysis Services refreshes can return large amounts of data. For such queries, data is temporarily stored on the gateway machine. This data storage continues until all data is received from the data source. The data is then sent back to the cloud service. This process is called spooling.
Download and install a standard gateway

1)     Download Standard Gateway

2)     In the gateway installer, keep the default installation path, accept the terms of use, and then select Install… Read On: