Scenario Recap
* You are working in Dataflow Gen2 inside a Fabric workspace .
* Dataflow1 returns 500 rows.
* You want to identify the minimum and maximum values for each column in the query results.
Key Concept: Column Profiling in Power Query (Fabric Dataflows)
In Power Query (used in Dataflows), profiling tools help you inspect and understand data. The following profiling features are available:
* Column quality # Shows % valid, % error, % empty values.
* Does not show min/max values.
* Column distribution # Shows distinct and unique value distribution (frequency).
* Does not show min/max values.
* Column profile # Provides statistics for each column including:
* Minimum value
* Maximum value
* Average, Standard deviation, Count, etc.
* This is the feature required here.
* Details pane # Displays the profiling results when profiling options (such as column profile) are enabled.
Correct Answer Breakdown
B). Show column profile in details pane
* Must be selected to display min/max, averages, and distribution in the details pane.
C). Enable details pane
* Required to actually display the profiling results. Without enabling the details pane, you cannot see column profiles.
E). Enable column profile
* Enables the calculation of statistics (min, max, avg, etc.) for each column.
These three together give you the ability to see min and max values .
Why the Other Options Are Incorrect
A). Show column quality details
* Shows only valid/empty/error statistics. No min/max.
D). Show column value distribution
* Displays distinct/unique values and counts but does not calculate min/max.
Summary
To identify min and max values per column in a Fabric Dataflow, you must:
* Enable the details pane
* Enable column profile
* Show column profile in details pane
Correct answers: B, C, E
References
* Data profiling tools in Power Query
* Column profiling options in Power Query
* Fabric Dataflows Gen2 overview