Creating dataflows in Power BI - Interactive Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to start creating a new dataflow in Power BI service.

Power BI

Go to workspace and click on [1] to create a new dataflow.

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

ANew report

BNew dashboard

CNew dataflow

DNew dataset

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'New report' instead of 'New dataflow'.

Selecting 'New dataset' which is different from dataflow.

To create a dataflow, you must select 'New dataflow' in the workspace.

2fill in blank

medium

Complete the code to add a new entity by connecting to a data source in the dataflow editor.

Power BI

In the dataflow editor, click on [1] to connect to a new data source.

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

AAdd tables

BAdd queries

CAdd data source

DAdd new entities

Attempts:

3 left

💡 Hint

Common Mistakes

Selecting 'Add tables' which is not the exact option in dataflow editor.

Choosing 'Add data source' which is not a button in the editor.

To add new data, you click 'Add new entities' which lets you connect to data sources.

3fill in blank

hard

Fix the error in the M code to correctly reference the data source in the dataflow.

Power BI

let
    Source = [1]("https://example.com/data.csv")
in
    Source

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

ACsv.Document

BCsvFile.Document

CCsvFile.Contents

DCsv.Contents

Attempts:

3 left

💡 Hint

Common Mistakes

Using Csv.Contents which is for binary content, not CSV parsing.

Using CsvFile.Contents which does not exist.

The correct M function to load CSV content from a URL is Csv.Document.

4fill in blank

hard

Fill both blanks to filter rows and select columns in the dataflow query.

Power BI

let
    Source = Csv.Document("data.csv"),
    FilteredRows = Table.SelectRows(Source, each [Sales] [1] 1000),
    SelectedColumns = Table.SelectColumns(FilteredRows, [2])
in
    SelectedColumns

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

A>

B<

C{"Product", "Sales"}

D["Date", "Region"]

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' which filters sales less than 1000.

Selecting wrong columns like Date and Region.

The filter uses '>' to select sales greater than 1000, and columns selected are Product and Sales.

5fill in blank

hard

Fill all three blanks to create a calculated column in the dataflow query.

Power BI

let
    Source = Csv.Document("data.csv"),
    AddedColumn = Table.AddColumn(Source, [1], each [Sales] [2] [Cost]),
    RenamedColumn = Table.RenameColumns(AddedColumn, [3])
in
    RenamedColumn

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

A"Profit"

B-

C{{"OldName", "NewName"}}

D[{"Sales", "Revenue"}]

Attempts:

3 left

💡 Hint

Common Mistakes

Using '+' instead of '-' for calculation.

Incorrect rename mapping or wrong column names.

The new column is named 'Profit', calculated as Sales minus Cost, then renamed using the correct mapping.