Power Query and Data Transformation Flashcards
6 cards from real Microsoft Power BI practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 Power Query and Data Transformation flashcards as text
What language does Power Query use for its advanced editor transformations?
Answer: M language (M formula language)
Power Query uses M (also called the M formula language or Power Query Formula Language) to define data transformation steps.
What does the 'Remove Duplicates' step in Power Query do?
Answer: Keeps only the first occurrence of each duplicate row based on selected columns
Remove Duplicates keeps the first occurrence of each unique combination of values in selected columns and removes subsequent duplicate rows.
In Power Query, what does 'Unpivot Columns' do to a table?
Answer: Converts selected column headers and their values into attribute-value rows
Unpivot transforms wide-format data by turning multiple column headers into an Attribute column and their values into a Value column.
What is a 'Query Dependency' in Power Query?
Answer: A relationship between queries where one query references or is built upon another
A Query Dependency exists when one Power Query query uses another as its source, creating a dependency chain visible in the Query Dependencies view.
Which Power Query step type allows you to combine rows from two tables with the same columns?
Answer: Append Queries
Append Queries combines rows from two or more tables with matching column structures, stacking them vertically.
What does 'Merge Queries' do in Power Query?
Answer: Joins two tables based on matching key columns, similar to a SQL JOIN
Merge Queries performs a join between two tables based on one or more matching key columns, with options for Left Outer, Inner, Full Outer, and other join types.