nerdexam
Microsoft

PL-200 · Question #214

You plan to create a dataflow by using Power Query to transform the data. You observe that some cells display an error instead of the expected data. You need to obtain more details about the errors…

The correct answer is C. Select the cell with the error. In Power Query, clicking directly on a cell that shows an error reveals the full error message and technical details in the preview pane below the grid.

Configure Microsoft Dataverse

Question

You plan to create a dataflow by using Power Query to transform the data. You observe that some cells display an error instead of the expected data. You need to obtain more details about the errors. What should you do?

Options

  • ASelect the row that includes the cell with the error.
  • BUse the Flow Checker.
  • CSelect the cell with the error.
  • DUse the App Checker.
  • EUse the Advanced Editor.

How the community answered

(19 responses)
  • B
    5% (1)
  • C
    84% (16)
  • E
    11% (2)

Why each option

In Power Query, clicking directly on a cell that shows an error reveals the full error message and technical details in the preview pane below the grid.

ASelect the row that includes the cell with the error.

Selecting the entire row highlights all values in that row but does not surface the structured error details for the specific errored cell.

BUse the Flow Checker.

Flow Checker is a Power Automate tool that validates the structure and connections of a cloud flow - it has no role in Power Query dataflow diagnostics.

CSelect the cell with the error.Correct

When you select a cell containing an error in Power Query's data preview, the editor displays the complete error record - including the error reason, message, and detail fields - in the lower preview area, giving specific information needed to diagnose and fix the transformation issue.

DUse the App Checker.

App Checker is a Power Apps tool that identifies issues in a canvas or model-driven app and is unrelated to Power Query dataflow errors.

EUse the Advanced Editor.

The Advanced Editor displays the raw M query code for the current step, which shows the transformation logic but does not expose runtime error details for individual cell values.

Concept tested: Diagnosing cell-level errors in Power Query dataflows

Source: https://learn.microsoft.com/en-us/power-query/dealing-with-errors

Topics

#Power Query#Dataflows#Error Inspection#Data Transformation

Community Discussion

No community discussion yet for this question.

Full PL-200 Practice