Power Query and Data Transformation Flashcards

What happens when you disable 'Include in Report Refresh' for a query in Power Query?

Answer: The query is excluded from scheduled and manual dataset refreshes

Disabling 'Include in Report Refresh' prevents a query from running during refresh cycles, which is useful for static reference tables that never change.

What is the 'List.Generate' function used for in Power Query M?

Answer: Generating a list of values by iterating with an initial state, condition, and transformation

List.Generate creates a list by iterating with an initial state, a condition to continue, and a step function, similar to a while loop.

Which Power Query join type returns only rows that match in both tables?

Answer: Inner

An Inner join returns only the rows where the key columns match in both the left and right tables.

What does the 'Conditional Column' feature in Power Query allow you to do?

Answer: Add a new column with values determined by if/then/else rules without writing M code

Conditional Column provides a UI-based way to create a new column with values based on if/then/else logic, generating M code automatically.

What is the benefit of enabling 'Fast Combine' (Ignore Privacy Levels) in Power Query?

Answer: It allows combining data from sources with different privacy levels, bypassing firewall checks for performance

Fast Combine ignores data privacy level checks when combining data sources, which can improve performance but may expose sensitive data to other sources.

What Power Query operation would you use to split a column containing 'FirstName LastName' into two separate columns?

Answer: Split Column by Delimiter

Split Column by Delimiter divides a text column into multiple columns based on a specified separator character, such as a space.