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.

Practice

1. What is the main purpose of creating a dataflow in Power BI?

easy

A. To create visual charts and graphs

B. To prepare and clean data once for use in multiple reports

C. To write DAX formulas for calculations

D. To schedule report email delivery

Solution

1. Step 1: Understand dataflow purpose

   Dataflows are designed to prepare and clean data centrally.

2. Step 2: Compare options

   Creating visuals and writing DAX are report tasks, not dataflow tasks.

3. Final Answer:

   To prepare and clean data once for use in multiple reports -> Option B

4. Quick Check:

   Dataflows centralize data prep = A [OK]

Hint: Dataflows focus on data prep, not visuals or formulas [OK]

Common Mistakes:

• Confusing dataflows with report visuals
• Thinking dataflows create charts
• Assuming dataflows handle email scheduling

2. Which of the following is the correct first step to create a dataflow in Power BI Service?

easy

A. Create a new report and add visuals

B. Open Power BI Desktop and click 'Get Data'

C. Go to workspace > New > Dataflow

D. Write a DAX measure in the report

Solution

1. Step 1: Identify dataflow creation location

   Dataflows are created in Power BI Service under a workspace.

2. Step 2: Verify correct menu path

   The correct path is Workspace > New > Dataflow, not Power BI Desktop or report creation.

3. Final Answer:

   Go to workspace > New > Dataflow -> Option C

4. Quick Check:

   Create dataflow in service workspace = C [OK]

Hint: Dataflows start in Power BI Service workspace, not Desktop [OK]

Common Mistakes:

• Trying to create dataflows in Power BI Desktop
• Confusing dataflows with reports
• Starting with DAX instead of data preparation

3. Consider this scenario: You create a dataflow that connects to an Excel file and applies a filter to keep only rows where Sales > 1000. What will happen when you refresh the dataflow?

medium

A. The dataflow will load all rows from Excel without filtering

B. The dataflow will refresh only if the Excel file is open

C. The dataflow will fail because filters are not allowed

D. The dataflow will load only rows where Sales > 1000

Solution

1. Step 1: Understand dataflow refresh behavior

   Dataflows apply all transformations including filters during refresh.

2. Step 2: Apply filter effect

   Only rows meeting Sales > 1000 condition are loaded into the dataflow.

3. Final Answer:

   The dataflow will load only rows where Sales > 1000 -> Option D

4. Quick Check:

   Filters apply on refresh = B [OK]

Hint: Filters in dataflows apply automatically on refresh [OK]

Common Mistakes:

• Thinking filters don't apply in dataflows
• Assuming dataflows need source files open
• Believing dataflows load all data regardless of filters

4. You created a dataflow but it fails to refresh with an error saying "Invalid credentials". What is the most likely cause and fix?

medium

A. The data source credentials are missing or expired; update credentials in dataflow settings

B. The dataflow name is invalid; rename the dataflow

C. The Power BI Service is down; wait and retry later

D. The dataflow has too many columns; reduce columns

Solution

1. Step 1: Analyze error message

   "Invalid credentials" means Power BI cannot access the data source due to authentication issues.

2. Step 2: Identify fix

   Updating or re-entering credentials in dataflow settings resolves this issue.

3. Final Answer:

   The data source credentials are missing or expired; update credentials in dataflow settings -> Option A

4. Quick Check:

   Invalid credentials = update data source login [OK]

Hint: Check and update data source credentials when refresh fails [OK]

Common Mistakes:

• Ignoring credential errors and blaming dataflow name
• Assuming service outage without checking credentials
• Thinking column count causes credential errors

5. You want to create a dataflow that combines data from two different SQL databases and refreshes daily. Which approach is best to ensure efficient and maintainable dataflows?

hard

A. Create two separate dataflows for each database, then create a third dataflow to merge their outputs

B. Create one dataflow that connects to both databases and merges data in a single query

C. Create one dataflow per database and merge data only in Power BI Desktop reports

D. Create multiple reports instead of dataflows to handle merging

Solution

1. Step 1: Consider modular design

   Separating dataflows by source improves maintainability and reusability.

2. Step 2: Combine dataflows for merging

   Creating a third dataflow to merge outputs centralizes transformation and refresh logic.

3. Final Answer:

   Create two separate dataflows for each database, then create a third dataflow to merge their outputs -> Option A

4. Quick Check:

   Modular dataflows + merge = A [OK]

Hint: Split sources, then merge in a separate dataflow for clarity [OK]

Common Mistakes:

• Merging different sources in one complex dataflow
• Merging only in reports causing repeated work
• Avoiding modular dataflows for easier updates