Power Query interface overview in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to load data into Power Query by selecting the correct button.

Power BI

Click the [1] button to import data from an Excel file.

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

AClose & Load

BRefresh

CTransform Data

DGet Data

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'Close & Load' which is for loading data after editing.

Selecting 'Transform Data' which opens the editor but does not import data.

Clicking 'Refresh' which updates existing data.

The Get Data button is used to import data into Power Query from various sources like Excel files.

2fill in blank

medium

Complete the code to rename a column in Power Query using the correct menu option.

Power BI

Right-click the column header and select [1] to change the column name.

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

ARename

BRemove

CDuplicate

DSplit Column

Attempts:

3 left

💡 Hint

Common Mistakes

Selecting 'Remove' which deletes the column.

Choosing 'Duplicate' which copies the column.

Picking 'Split Column' which divides the column into parts.

To rename a column, you right-click the header and choose Rename.

3fill in blank

hard

Fix the error in the step name by selecting the correct syntax for referencing the previous step in Power Query.

Power BI

ChangedType = Table.TransformColumnTypes([1], {{"Age", Int64.Type}})

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

AChangedType

BSource

CPreviousStep

Dsource

Attempts:

3 left

💡 Hint

Common Mistakes

Using lowercase 'source' which causes an error.

Referencing a step name that does not exist.

Using the current step name instead of the previous step.

The previous step is usually named Source with a capital S in Power Query. It is case-sensitive.

4fill in blank

hard

Fill both blanks to filter rows where the 'Status' column equals 'Active' in Power Query.

Power BI

FilteredRows = Table.SelectRows(Source, [1][[2]] = "Active")

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

Aeach

BStatus

CSource

DTable

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'Source' or 'Table' instead of 'each' in the first blank.

Using wrong column names or misspelling 'Status'.

The each keyword is used to define a function for filtering, and Status is the column name to check.

5fill in blank

hard

Fill all three blanks to create a new column 'AgeGroup' that categorizes ages in Power Query.

Power BI

AddColumn = Table.AddColumn(Source, "AgeGroup", each if [1] < 18 then [2] else [3])

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

A[Age]

B"Minor"

C"Adult"

DAge

Attempts:

3 left

💡 Hint

Common Mistakes

Not using square brackets for the column name.

Missing quotes around text labels.

Using variable names without quotes for text.

The expression uses the age column [Age] to check if less than 18, then assigns the text "Minor", else "Adult".