Power Query and Data Transformation Flashcards

What does 'Promote Headers' do in Power Query?

Answer: Uses the first row of data as the column headers

Promote Headers takes the first row of the dataset and converts it into the column header names.

Which data type in Power Query stores whole numbers without decimal places?

Answer: Whole Number

Whole Number data type in Power Query stores integers (positive and negative whole numbers) without any decimal precision.

What happens when you set a query's load setting to 'Enable Load' off in Power Query?

Answer: The query runs but its results are not loaded into the data model

Disabling 'Enable Load' keeps the query available as a staging or reference query without adding its data to the final model.

What is the purpose of a 'Parameter' in Power Query?

Answer: A variable value that can be used dynamically within query steps

A Power Query Parameter is a reusable variable that can be used in query steps, source paths, or filter conditions.

What does 'Remove Duplicates' do in Power Query when applied to a column?

Answer: Keeps only the first occurrence of each unique value in the selected column, removing subsequent duplicates

Remove Duplicates on a column retains the first occurrence of each unique value and deletes all subsequent duplicate rows.

What is the Advanced Editor in Power Query used for?

Answer: Viewing and editing the full M code for a query

The Advanced Editor displays the complete M language script for a query, allowing direct code editing of all transformation steps.