Data gateway setup in Power BI - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a data gateway in Power BI?

A data gateway is a bridge that securely transfers data between on-premises data sources and Power BI cloud services.

beginner

Name the two types of data gateways available in Power BI.

The two types are: 1) Personal mode gateway, used by one user, and 2) Standard mode gateway (also called Enterprise gateway), used by multiple users and supports scheduled refresh.

beginner

What is the first step to set up a data gateway?

Download and install the data gateway software on a computer that can access your on-premises data sources.

intermediate

Why is it important to keep the data gateway machine always on?

Because the gateway needs to be online to allow Power BI to refresh data and access on-premises sources anytime.

intermediate

How do you add data sources to a data gateway after installation?

In the Power BI service, go to the gateway settings, select your gateway, and add data sources by providing connection details and credentials.

What does a Power BI data gateway do?

A Transfers data securely between on-premises sources and Power BI cloud

B Creates visualizations automatically

C Connects cloud data sources to on-premises reports

D Stores data in the cloud permanently

A data gateway securely transfers data between your on-premises data sources and Power BI cloud services.

Which data gateway type supports multiple users and scheduled refresh?

A Personal mode gateway

B Standard mode gateway

C Cloud gateway

D Mobile gateway

The Standard mode gateway (Enterprise gateway) supports multiple users and scheduled data refresh.

Where do you configure data sources for a Power BI gateway?

A Power BI Desktop

B Power BI mobile app

C Power BI service gateway settings

D Windows Control Panel

Data sources are configured in the Power BI service under the gateway settings.

What is required on the machine where you install the data gateway?

A Only internet access

B No network connection

C Only access to cloud data

D Internet access and access to on-premises data sources

The gateway machine must have internet access and be able to reach on-premises data sources.

Why should the data gateway machine stay powered on?

A To allow scheduled data refresh and live queries

B To save electricity

C To update Power BI Desktop

D To run reports locally

The gateway must be online to enable scheduled refresh and live data queries.

Explain the purpose of a data gateway in Power BI and describe the two types available.

Think about how Power BI connects to data behind your firewall.

Describe the steps to set up and configure a data gateway for your organization.

Consider installation, registration, and configuration.