You have a Fabric tenant that contains a warehouse. You use a dataflow to load a new dataset from OneLake to the warehouse. You need to add a PowerQuery step to identify the maximum values for the num

The correct answer is D. Table.Profile. Table.Profile is the correct Power Query M function because it returns a summary statistics table for each column, including count, null count, distinct count, minimum, maximum, average, and standard deviation. This is the direct way to identify maximum values for all numeric col

Submitted by paula_co· Apr 18, 2026Prepare data

Question

You have a Fabric tenant that contains a warehouse. You use a dataflow to load a new dataset from OneLake to the warehouse. You need to add a PowerQuery step to identify the maximum values for the numeric columns. Which function should you include in the step?

Options

ATable.MaxN
BTable.Max
CTable.Range
DTable.Profile

How the community answered

(40 responses)

A
8% (3)
B
3% (1)
C
15% (6)
D
75% (30)

Explanation

Table.Profile is the correct Power Query M function because it returns a summary statistics table for each column, including count, null count, distinct count, minimum, maximum, average, and standard deviation. This is the direct way to identify maximum values for all numeric columns in a single step. Table.Max (B) returns a single row from a table based on a key column comparison, not column-level statistics. Table.MaxN (A) returns the top N rows by a key, and Table.Range (C) returns a positional subset of rows - neither provides column-level max statistics.

Topics

#Power Query M#Data Profiling#Dataflows#Fabric Warehouse

Community Discussion

No community discussion yet for this question.

Full DP-600 Practice