Multiple data sources in one report in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to load data from two different sources in Power BI.

Power BI

Source1 = Sql.Database("ServerName", [1])

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

A"ServerName"

B"Table1"

C"DataSource1"

D"Database1"

Attempts:

3 left

💡 Hint

Common Mistakes

Using the table name instead of the database name.

Repeating the server name twice.

In Power BI, to connect to a SQL Server database, you specify the database name as the second argument in Sql.Database.

2fill in blank

medium

Complete the code to merge two tables from different data sources in Power BI.

Power BI

MergedTable = Table.NestedJoin(Source1, {"ID"}, [1], {"ID"}, "NewTable")

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

ASource2

BSource1

CSource3

DSource4

Attempts:

3 left

💡 Hint

Common Mistakes

Joining the same source to itself.

Using a source that is not loaded.

To merge tables from two different sources, you join Source1 with Source2 on the common column.

3fill in blank

hard

Fix the error in the DAX measure to calculate total sales from two different tables.

Power BI

TotalSales = SUM([1][SalesAmount]) + SUM(Source2[SalesAmount])

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

ASource1

BSource3

CSource4

DSource5

Attempts:

3 left

💡 Hint

Common Mistakes

Using a table name that does not exist.

Misspelling the table name.

The measure must sum the SalesAmount column from both Source1 and Source2 tables.

4fill in blank

hard

Fill both blanks to create a relationship between two tables from different sources in Power BI.

Power BI

Relationship = Table.AddRelationship([1], "CustomerID", [2], "CustomerID")

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

ASource1

BSource2

CSource3

DSource4

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping the tables in the relationship.

Using tables that do not share the key.

To relate two tables, specify the first table and the second table with the common key column.

5fill in blank

hard

Fill all three blanks to create a calculated table combining data from two sources with a filter.

Power BI

CombinedTable = FILTER(UNION([1], [2]), [3] > 1000)

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

ASource1

BSource2

CSalesAmount

DCustomerID

Attempts:

3 left

💡 Hint

Common Mistakes

Using a column name instead of a table name in the first two blanks.

Filtering on a column not present in the combined table.

The UNION combines two tables, and FILTER applies a condition on the SalesAmount column.