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