How to Identify Min and Max Values in Dataflow Data View

DP-600 By islever Editorial Last updated

Transform data

Short answer

BCE Enable column profile, Enable details pane, and Show column profile in details pane to view min and max values.

Question

You have a Fabric workspace named Workspace1 that contains a dataflow named Dataflow1. Dataflow1 returns 500 rows of data. You need to identify the min and max values for each column in the query results. Which three Data view options should you select? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.
  1. Show column value distribution
  2. Enable column profile Correct Answer
  3. Show column profile in details pane Correct Answer
  4. Show column quality details
  5. Enable details pane Correct Answer

Key Takeaways

To view min and max values in a dataflow, you must enable the column profile, enable the details pane, and show the column profile within that details pane.

Identifying the minimum and maximum values for columns in a Fabric dataflow requires enabling specific data view options. This page confirms the correct combination of settings to display column profile statistics in the details pane.

Common mistake: Selecting "Show column value distribution" (A) or "Show column quality details" (D) instead of the profile and details pane options, misunderstanding where min/max statistics are displayed.

Expert Analysis

Why the Answer Is Correct

To identify the minimum and maximum values for each column in a Fabric dataflow, you must enable column profiling and ensure the results are visible. Option B ("Enable column profile") turns on the calculation of these statistics. Option E ("Enable details pane") makes the pane available, and Option C ("Show column profile in details pane") directs the min/max statistics to be rendered there. Together, BCE provides the complete path to visualize the min and max values.

Why the Other Options Are Wrong

Option A ("Show column value distribution") displays a visual chart of value frequencies, not the discrete min and max statistics. Option D ("Show column quality details") reveals the percentage of valid, error, and empty values but does not include min/max metrics. Option E alone ("Enable details pane") only opens the pane but does not populate it with column profile data without C and B.

Community Comment Notes

The community consensus strongly supports BCE. Commenters point out that B and E are prerequisites to display the output of C, as bigdave987 noted: "B - Enable column profile... E - Enable details pane... C - Show column profile in details pane". Another user clarified the distinction by stating that A is for distribution and D is for quality, neither of which provide min/max values.

Official Reference

https://learn.microsoft.com/en-us/power-query/data-profiling

This link opens the official vendor documentation in a new tab.

Exam Strategy

When asked how to view specific data profiling statistics like min or max, remember the three-step UI toggle: enable the profile, enable the pane, and show the profile in the pane. Distinguish between "quality" (valid/error/empty) and "profile" (min/max/distinct).

Community Votes

BCE
100%

100% of anonymous learners picked answer BCE. Votes are pick records left by other test-takers — they are not the verified answer.

Discussion 7 contributions

Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors, not of islever. The comments shown first are the most substantive of the thread — ranked by depth, community endorsement and relevance; expand the list below to read the rest.

From public community threads 7

  1. taphyoe 👍 16
    B Enable column profile E Enable details pane C Show column profile in details pane
  2. bigdave987 👍 4
    B - Enable column profile; this needs to be enabled to be able to select... C - Show column profile in details pane E - Enable details pane; this needs to be enabled to be able to see the output of (C)
  3. 282b85d 👍 4
    Column quality: % of Valid, Error, Empty Column distribution: Number of distinct and unique values
  4. 72bd3bc 👍 3
    I have checked in Fabric. B. profile E. Enable detail pane C Show column profile in details pane.
  5. stilferx 👍 2
    IMHO, B&C&E looks right. Not A (what distribution?), nor D (what quantity?)
Show 2 more comments
  1. AGTraining 👍 7
    answer is BEC
  2. woliveiras 👍 1
    BCE are the correct answers.

Reader comments & corrections

No reader corrections yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Submitted for moderation before publishing. Keep it helpful and respectful.

Fabric Deployment Pipeline Folder Structure Behavior

S-grade

Accessing OneLake Shortcuts in Fabric Notebooks

S-grade

Direct Lake Fallback to DirectQuery with Row-Level Security

S-grade

Displaying All Rows in Power BI Python Visuals

S-grade

Practice All DP-600 Questions

Access 115 questions with complete answers and detailed explanations.

View Full DP-600 Practice Test →

← Back to DP-600 Study Guide