Data gateway setup in Power BI - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding the Purpose of a Data Gateway

Why do we need a data gateway in Power BI when connecting to on-premises data sources?

A To securely transfer data from on-premises sources to the Power BI service without exposing the data source directly to the internet.

B To create visualizations directly on the local machine without using the Power BI service.

C To replace the need for Power BI Desktop when building reports.

D To store data permanently in the cloud instead of on-premises.

💡 Hint

Think about how data moves securely from your local environment to the cloud.

A data gateway acts as a secure bridge that allows Power BI service to access on-premises data sources without opening direct internet access to those sources.

🎯 Scenario

intermediate

Choosing the Right Gateway Mode

Your company has multiple users who need to refresh reports from the same on-premises SQL Server database. Which gateway mode should you choose to allow all users to share the same connection?

A Personal mode, because it is easier to set up for individual users.

B Enterprise mode, because it supports multiple users sharing the same gateway and connections.

C No gateway is needed if users have Power BI Desktop installed.

D Use a VPN connection instead of a gateway.

💡 Hint

Consider which mode supports multiple users and centralized management.

Enterprise mode allows multiple users to share the same gateway and manage connections centrally, which is ideal for organizational use.

🔧 Formula Fix

advanced

Troubleshooting Gateway Connection Failures

You installed an enterprise data gateway and configured it to connect to an on-premises database. However, scheduled refreshes fail with an error saying the gateway cannot connect. Which of the following is the most likely cause?

A The Power BI Desktop file is saved in the cloud instead of locally.

B The report uses DirectQuery instead of Import mode.

C The Power BI service is offline.

D The gateway service is not running on the machine where it was installed.

💡 Hint

Check the status of the gateway software on the machine.

If the gateway service is stopped or not running, it cannot relay data requests, causing refresh failures.

❓ visualization

advanced

Monitoring Gateway Performance

You want to create a dashboard in Power BI to monitor the health and performance of your data gateways. Which of the following data sources should you connect to for this purpose?

A The Power BI Desktop report file (.pbix) itself.

B Your on-premises SQL Server database used for business data.

C Power BI Gateway Performance Monitoring dataset available in the Power BI service.

D A CSV file exported from Power BI Desktop.

💡 Hint

Think about where gateway health data is stored and accessible.

Power BI provides a built-in dataset for monitoring gateway performance, which can be used to build dashboards on gateway health.

❓ data_modeling

expert

Configuring Gateway for Multiple Data Sources with Different Credentials

You have a data gateway configured with connections to two different on-premises data sources: a SQL Server database and a SharePoint folder. Each requires different credentials. How should you configure the gateway to handle this scenario?

A Create separate data source entries in the gateway for each data source, each with its own credentials.

B Use the same credentials for both data sources in the gateway settings.

C Configure only one data source in the gateway and combine data in Power BI Desktop.

D Install two separate gateways, one for each data source.

💡 Hint

Think about how gateways manage multiple connections and credentials.

Each data source requires its own entry and credentials in the gateway to authenticate properly and refresh data.