Dataflow entities in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to reference a dataflow entity in Power BI.

Power BI

let Source = PowerBI.Dataflows(null)[1]

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

A["Entities"]

B["Entity"]

C["Tables"]

D["Data"]

Attempts:

3 left

💡 Hint

Common Mistakes

Using singular form like 'Entity' instead of 'Entities'.

Using 'Tables' which is not the correct property in dataflows.

In Power BI dataflows, the correct way to access all entities is using ["Entities"].

2fill in blank

medium

Complete the code to select a specific entity named 'Sales' from a dataflow.

Power BI

let SalesEntity = Source[1]

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

A[Sales]

B["Sales"]

C.Sales

DSales

Attempts:

3 left

💡 Hint

Common Mistakes

Omitting quotes around the entity name.

Using dot notation which is not valid for dynamic names.

To select an entity by name in Power Query, use square brackets with the entity name as a string, like ["Sales"].

3fill in blank

hard

Fix the error in the code to correctly load the 'Customers' entity from a dataflow.

Power BI

let Customers = PowerBI.Dataflows(null)[Entities][1]

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

A["Customers"]

B[Customers]

C.Customers

DCustomers

Attempts:

3 left

💡 Hint

Common Mistakes

Using dot notation instead of square brackets.

Not using quotes around the entity name.

The entity name must be in quotes and inside square brackets to access it correctly.

4fill in blank

hard

Fill both blanks to filter rows where 'Region' equals 'West' in the 'Sales' entity.

Power BI

let Filtered = Source[Entities]["Sales"][1](each [2] = "West")

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

ATable.SelectRows

BRegion

CSales

DTable.Filter

Attempts:

3 left

💡 Hint

Common Mistakes

Using incorrect function names like 'Table.Filter'.

Using the entity name instead of the column name in the condition.

Use Table.SelectRows to filter rows and specify the column name 'Region' in the condition.

5fill in blank

hard

Fill both blanks to create a new column 'Total' as the sum of 'Quantity' and 'Price' in the 'Orders' entity.

Power BI

let AddedColumn = Table.AddColumn(Source[Entities]["Orders"], "Total", each [1] + [2], type number)

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

AQuantity

BPrice

DTable.TransformColumns

Attempts:

3 left

💡 Hint

Common Mistakes

Adding extra function calls after Table.AddColumn.

Using incorrect column names or omitting quotes.

Use the column names 'Quantity' and 'Price' inside the function to add them. No additional function call is needed after Table.AddColumn.