DirectQuery vs Import mode in Power BI - Interactive Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to set the data connectivity mode to Import in Power BI.

Power BI

let Source = Sql.Database("ServerName", "DatabaseName", [[1] = "Import"])

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

ADataConnectivityMode

BConnectionMode

CQueryMode

DLoadMode

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'ConnectionMode' instead of 'DataConnectivityMode'.

Confusing 'QueryMode' with the correct property.

The correct property to set the data connectivity mode in Power BI's M query is DataConnectivityMode. Setting it to "Import" loads data into Power BI's cache.

2fill in blank

medium

Complete the DAX formula to calculate total sales when using DirectQuery mode.

Power BI

Total Sales = SUM([1][SalesAmount])

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

ASalesData

BSalesTable

CSales

DSalesFact

Attempts:

3 left

💡 Hint

Common Mistakes

Using a table name that does not exist in the model.

Forgetting to specify the table before the column.

The table name in the model is Sales. The SUM function adds up the SalesAmount column values.

3fill in blank

hard

Fix the error in the M query to enable DirectQuery mode.

Power BI

let Source = Sql.Database("ServerName", "DatabaseName", [[1] = "DirectQuery"])

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

AConnectionMode

BDataConnectivityMode

CQueryMode

DLoadMode

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'ConnectionMode' which is not recognized.

Using 'QueryMode' which is invalid.

The correct property to enable DirectQuery mode is DataConnectivityMode. Other options are invalid and cause errors.

4fill in blank

hard

Fill both blanks to create a DAX measure that calculates average sales only for DirectQuery mode data.

Power BI

Average Sales = CALCULATE(AVERAGE([1][SalesAmount]), [2][Mode] = "DirectQuery")

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

ASales

BSalesData

CMode

DDataMode

Attempts:

3 left

💡 Hint

Common Mistakes

Using incorrect table or column names.

Confusing the filter condition syntax.

The table is Sales and the column indicating mode is DataMode. This filters data to DirectQuery mode only.

5fill in blank

hard

Fill all three blanks to write a DAX expression that counts rows from Import mode data where sales exceed 1000.

Power BI

Count High Sales = COUNTROWS(FILTER([1], [2][[3]] > 1000 && [2][Mode] = "Import"))

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

ASales

BSalesData

CSalesAmount

DSalesTable

Attempts:

3 left

💡 Hint

Common Mistakes

Using different table names in FILTER and column references.

Using wrong column names for sales amount.

The table is SalesData. The column to check sales amount is SalesAmount. The filter applies to the same table alias SalesData.