Data gateway setup in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to specify the type of data gateway to install.

Power BI

Install the [1] gateway to enable cloud data refresh.

Drag options to blanks, or click blank then click option'

Alocal

Bpersonal

Centerprise

Dremote

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'enterprise' which is for organizational use.

Confusing 'local' or 'remote' which are not official gateway types.

The personal gateway is used for individual use and supports scheduled refresh for cloud datasets.

2fill in blank

medium

Complete the code to add a data source to the gateway.

Power BI

Use the gateway management portal to add a [1] data source.

Drag options to blanks, or click blank then click option'

Avirtual

Bcloud

Cexternal

Don-premises

Attempts:

3 left

💡 Hint

Common Mistakes

Selecting 'cloud' which does not require a gateway.

Choosing 'external' or 'virtual' which are not standard terms here.

Gateways connect Power BI to on-premises data sources like local databases.

3fill in blank

hard

Fix the error in the gateway connection string.

Power BI

Data source connection string must include server=[1]; database=SalesDB;

Drag options to blanks, or click blank then click option'

Ahttp://server

Buser=admin

Clocalhost

Dport=1433

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'http://server' which is invalid in connection strings.

Putting user credentials in the server field.

The connection string requires the server name or address, such as localhost for local machine.

4fill in blank

hard

Fill both blanks to configure gateway cluster and recovery key.

Power BI

Set gateway cluster name to [1] and enter recovery key as [2] during setup.

Drag options to blanks, or click blank then click option'

AMyGatewayCluster

B1234-5678-ABCD

CDefaultCluster

Dpassword123

Attempts:

3 left

💡 Hint

Common Mistakes

Using generic names like 'DefaultCluster' without customization.

Choosing weak or common passwords as recovery keys.

The cluster name identifies the gateway group, and the recovery key secures the gateway configuration.

5fill in blank

hard

Fill all three blanks to complete the gateway refresh schedule setup.

Power BI

Configure refresh frequency as [1], start time at [2], and timezone set to [3].

Drag options to blanks, or click blank then click option'

Adaily

B02:00

CUTC

Dweekly

Attempts:

3 left

💡 Hint

Common Mistakes

Setting refresh frequency to 'weekly' when daily updates are needed.

Using incorrect time format or timezone.

Setting refresh to daily at 02:00 UTC ensures data updates every day early morning.