Power Query interview questionsTechnical interview questions
← Interview & exam prep
Technical interview questions

Power Query interview questions

18 questions from beginner to advanced, each with the correct answer and a one-line explanation of why. Study them here, or take them as a timed test.

18 questionsBeginner 10 · Intermediate 8Answers + explanations
Take it as a timed test
Free PDF
All 389 questions & answers, in one file

DAX, Excel, Power BI, Fabric, certification practice and analyst interviews — every answer with the reason behind it. Print it, study it offline.

Instant download, plus the free Tuesday briefing. Unsubscribe in one click.

Beginner 10 questions

1Query folding means…

  1. Steps are translated to the source's native query and run there
  2. Merging two queries
  3. Pivoting data
  4. Caching results locally
  5. Folding columns visually
Show answerHide answer

A · Steps are translated to the source's native query and run there Folding pushes transformations back to the source (e.g., SQL) for efficiency.

2To stack rows of two queries that share the same columns, use…

  1. Group By
  2. Merge
  3. Append
  4. Join
  5. Expand
Show answerHide answer

C · Append Append stacks rows (like UNION). Merge joins on keys (like JOIN).

3A Merge in Power Query is most like a…

  1. SQL UNION
  2. Append
  3. Pivot
  4. SQL JOIN on key columns
  5. Group By
Show answerHide answer

D · SQL JOIN on key columns Merge matches rows across queries by key — a join.

4The M language is…

  1. Case-insensitive, like DAX
  2. Python-based
  3. Case-sensitive and functional
  4. A dialect of SQL
  5. Identical to DAX
Show answerHide answer

C · Case-sensitive and functional M is case-sensitive and functional — a common surprise for DAX users.

5'Unpivot Columns' transforms…

  1. Two queries into one
  2. Rows into columns
  3. Text into numbers
  4. Nothing
  5. Wide columns into attribute/value row pairs
Show answerHide answer

E · Wide columns into attribute/value row pairs Unpivot turns columns into rows (attribute + value), the reverse of pivot.

6Reference (vs Duplicate) a query means the new query…

  1. Loads to the model
  2. Becomes a parameter
  3. Deletes the original
  4. Points to the output of the source query
  5. Copies all steps independently
Show answerHide answer

D · Points to the output of the source query Reference builds on the other query's result; Duplicate copies its steps.

7Which typically BREAKS query folding?

  1. Table.Buffer
  2. Filtering rows
  3. Selecting columns
  4. Removing columns
  5. Renaming a column
Show answerHide answer

A · Table.Buffer Table.Buffer loads data into memory and stops further folding; the others usually fold.

8'Remove Duplicates' keeps…

  1. A random row
  2. The first occurrence
  3. The last occurrence
  4. No rows
  5. All rows
Show answerHide answer

B · The first occurrence It keeps the first occurrence of each duplicate and drops the rest.

9A column with the ABC/123 (any) type indicator means…

  1. Its data type is not yet defined
  2. It has errors
  3. It is text
  4. It is hidden
  5. It is a number
Show answerHide answer

A · Its data type is not yet defined The 'any' type means Power Query hasn't assigned a specific type — best to set one explicitly.

10Changing a column's data type is best done…

  1. Never
  2. Early, and once — to keep steps foldable and stable
  3. Only at the end
  4. In DAX instead
  5. With Table.Buffer
Show answerHide answer

B · Early, and once — to keep steps foldable and stable Set types deliberately (usually early); redundant late type changes can hurt folding and clarity.

Intermediate 8 questions

11Table.Buffer(table) …

  1. Loads the table into memory and prevents downstream folding
  2. Speeds up folding
  3. Creates a parameter
  4. Deletes rows
  5. Sorts the table
Show answerHide answer

A · Loads the table into memory and prevents downstream folding It materializes the table in memory — useful to avoid re-evaluation, but it blocks folding.

12In M, a Record is…

  1. An ordered list of values
  2. A single number
  3. A set of named fields
  4. Rows and columns
  5. A saved query
Show answerHide answer

C · A set of named fields Record = named fields [a=1, b=2]; List = ordered values; Table = rows/columns.

13Reliable incremental refresh needs…

  1. Manual refresh only
  2. RangeStart / RangeEnd datetime parameters over a foldable source
  3. Any custom column
  4. A Table.Buffer step
  5. A calculated column
Show answerHide answer

B · RangeStart / RangeEnd datetime parameters over a foldable source The RangeStart/RangeEnd parameters define partitions and must fold to the source.

14Row-level error handling in M uses…

  1. on error
  2. IFERROR
  3. try … otherwise
  4. catch()
  5. TryParse
Show answerHide answer

C · try … otherwise try expr otherwise fallback handles errors per value/row in M.

15Parameters in Power Query are mainly for…

  1. Storing measures
  2. Row-level security
  3. Defining relationships
  4. Making queries dynamic (paths, environments, filters)
  5. Formatting visuals
Show answerHide answer

D · Making queries dynamic (paths, environments, filters) Parameters externalize values so queries adapt without editing steps.

16To reference a value from the previous row (e.g., running total), a common approach is…

  1. Add an Index column, then offset/self-merge on it
  2. Use TEXTJOIN
  3. Use RELATED
  4. Enable iterative calc
  5. Use CALCULATE
Show answerHide answer

A · Add an Index column, then offset/self-merge on it Add an Index, then merge the table to itself on Index-1 (or use List.Range).

17The keyword 'each' is shorthand for…

  1. A list
  2. A record
  3. A function of one parameter named _
  4. A loop
  5. A comment
Show answerHide answer

C · A function of one parameter named _ each cond is sugar for (_) => cond; the underscore is the implicit parameter (usually the current row).

18Combining files from a folder creates…

  1. A parameter only
  2. A sample transform function applied to every file
  3. One giant text column
  4. A pivot table
  5. Nothing until refresh
Show answerHide answer

B · A sample transform function applied to every file The 'Combine Files' experience builds a helper function from a sample file and maps it over all files.

What changed lately? Latest Power Query (M) news, releases & questions →

Coming soon $19 one-time · early-access price
Prep Pro: full mock exams
  • Full-length, timed mock exams in the real PL-300, DP-600 and MO-201 format
  • Score breakdown by skill, with a study plan for your weak spots
  • New questions every month, written against the current exam outline

No payment now. We'll email you once, when it opens.

More technical interview questions