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 Power Query step to identify the maximum values for the…

The correct answer is C. Table.Profile. Table. Profile is a Power Query M function that generates a profile for each column in a table, providing various statistics. The function returns a table with information such as minimum, maximum, average, standard deviation, count, null count, and distinct count for each…

Submitted by rohit_dlh· 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 Power Query step to identify the maximum values for the numeric columns. Which function should you include in the step?

Options

ATable.Range
BTable.MaxN
CTable.Profile

How the community answered

(23 responses)

A
9% (2)
B
17% (4)
C
74% (17)

Explanation

Table. Profile is a Power Query M function that generates a profile for each column in a table, providing various statistics. The function returns a table with information such as minimum, maximum, average, standard deviation, count, null count, and distinct count for each column. https://learn.microsoft.com/en-us/powerquery-m/table-profile

Topics

#Power Query M#Dataflows#Data profiling#Microsoft Fabric

Community Discussion

No community discussion yet for this question.

Full DP-600 Practice