Power Query Data View Options for Column Information

DP-600 By islever Editorial Last updated

Transform data

Short answer

ACD Enable column profile, Show column value distribution, and Show column quality details to display the inline column information.

Question

You have a Microsoft Fabric tenant that contains a dataflow. You are exploring a new semantic model. From Power Query, you need to view column information as shown in the following exhibit. Which three Data view options should you select? Each correct answer presents part of the solution. - Exhibit: Power Query Data View Options for Column Information
  1. Show column value distribution Correct Answer
  2. Enable details pane
  3. Enable column profile Correct Answer
  4. Show column quality details Correct Answer
  5. Show column profile in details pane

Key Takeaways

The question tests the specific Power Query Data view options needed to display column profiling metrics; the common trap is selecting options related to the details pane instead of the main column view.

This guide identifies the three Data view options in Power Query required to display column value distribution, column profile, and column quality details for a semantic model in Microsoft Fabric. Selecting these options provides comprehensive column profiling directly in the query editor.

Common mistake: Choosing options B or E (Enable details pane / Show column profile in details pane) because users confuse the main column view profiling with the details pane view.

Expert Analysis

Why the Answer Is Correct

To view the column information as depicted in the exhibit (which shows column quality, value distribution, and profile statistics), you must enable the corresponding Data view options in Power Query. "Enable column profile" turns on the profiling feature at the bottom of the column view. "Show column value distribution" and "Show column quality details" toggle the visual distribution bars and quality percentages (Valid, Error, Empty) within that profile. Together, these three options (A, C, D) render the complete column information shown.

Why the Other Options Are Wrong

Options B and E ("Enable details pane" and "Show column profile in details pane") are incorrect because the exhibit displays the information directly in the main column view, not in a separate details pane. The details pane is a distinct panel that provides expanded profiling information, but the question asks for the options that display the information inline as shown. Since the question asks for exactly three options, and A, C, and D cover the inline display, B and E cannot be part of the solution.

Community Comment Notes

Multiple community members confirmed the ACD combination through hands-on testing, such as the user who "Tested it with a dataflow in Fabric". Another user supported ACD by noting that "simply there is no pane here, everything is showed in the upper box", which explicitly rules out the details pane options (B and E). Another commenter mentioned that selecting "Column profile" shows statistics and value distribution, validating the inclusion of option C.

Official Reference

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

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

Exam Strategy

When asked about Power Query Data view options, distinguish between inline column profiling and the details pane. If the exhibit shows metrics directly under or within the column headers, select the inline profile options (Column profile, Column quality, Column value distribution) rather than the details pane options.

Community Votes

ACD
72%
AD
28%

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

Discussion 11 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 11

  1. taphyoe 👍 22
    C Enable column profile A Show column value distribution D Show Column quality details
  2. Evincible 👍 7
    As per the screenshot, there are only 2 options to show that information: 1st is "Column Distribution" and 2nd is "Column Quality". I don't know why it is asking for 3 and when we select "Column profile" it shows statistics and value distribution.
  3. emmanuelkech 👍 4
    A: Show column value C: Enable column profile D: Show Column quality
  4. 282b85d 👍 3
    Show column value distribution: This option provides a visual representation of the distribution of values in each column, which is visible in the exhibit. Enable column profile: This option displays statistics and other detailed information about each column, including value distribution, which aligns with the data shown in the exhibit. Show column quality details: This option shows the quality of the data in each column, indicating valid, error, and empty values, as displayed in the exhibit.
  5. LyrikIngwer 👍 3
    Tested it with a dataflow in Fabric
Show 6 more comments
  1. gfors 👍 2
    Hm.Just tested this. I suggest this answers: C – enable column profile, E – Show column quality details, A-Show Column Value distribution. Dette er testet
  2. stilferx 👍 2
    IMHO, ACD is good. There is no example for details, so B and E are not needed
  3. nappi1 👍 1
    simply there is no pane here, everything is showed in the upper box
  4. woliveiras 👍 4
    ACD for sure. Tested
  5. woliveiras 👍 2
    ACD for sure
  6. schlammi 👍 1
    it was in the exam 27.03.25

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