Report Builder overview in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a new report page in Power BI Report Builder.

Power BI

ReportPage = ReportBuilder.[1]()

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

AAddPage

BCreatePage

CNewPage

DInsertPage

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'NewPage' which is not a valid method.

Confusing 'CreatePage' with 'AddPage'.

In Power BI Report Builder, you add a new report page using the AddPage() method.

2fill in blank

medium

Complete the code to add a table to the report body.

Power BI

reportBody.[1](table)

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

AAddTable

BBuildTable

CCreateTable

DInsertTable

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'InsertTable' which is not the correct method.

Confusing 'CreateTable' with 'AddTable'.

The AddTable() method adds a table to the report body in Report Builder.

3fill in blank

hard

Fix the error in the expression to set the data source for the dataset.

Power BI

dataset.DataSource = [1]

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

ACreateDataSource('SalesDB')

BNew DataSource('SalesDB')

CDataSource('SalesDB')

DNewDataSource('SalesDB')

Attempts:

3 left

💡 Hint

Common Mistakes

Using spaces in method names like 'New DataSource'.

Using 'CreateDataSource' which is not valid.

The correct syntax to create a new data source is NewDataSource('SalesDB') without spaces.

4fill in blank

hard

Fill both blanks to filter the dataset to only include sales greater than 1000.

Power BI

dataset.Filter = "[1] > [2]"

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

ASalesAmount

B1000

CQuantity

D500

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'Quantity' instead of 'SalesAmount'.

Using 500 instead of 1000.

The filter expression should compare SalesAmount to the value 1000.

5fill in blank

hard

Fill all three blanks to create a textbox with the title 'Total Sales' and set its font size to 14.

Power BI

textbox = reportBody.[1]()
textbox.Value = "[2]"
textbox.Style.[3] = 14

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

AAddTextbox

BTotal Sales

CFontSize

DCreateTextbox

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'CreateTextbox' instead of 'AddTextbox'.

Setting the value to something other than 'Total Sales'.

Using 'Font' instead of 'FontSize'.

You add a textbox with AddTextbox(), set its value to 'Total Sales', and set the font size using the FontSize style property.