PL-200 Question #214: Real Exam Question with Answer & Explanation

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.

Explanation

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.

Common mistakes.

• A. Selecting the entire row highlights all values in that row but does not surface the structured error details for the specific errored cell.
• B. 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.
• D. 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.
• E. 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

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

No community discussion yet for this question.