Microsoft Power BI Data Analyst Practice Question

The correct operation is 'Append Queries'. The 'Append' operation stacks data from multiple tables that have the same or similar schemas, creating a single table with all the rows from the source tables. This is ideal for combining datasets that are partitioned by time (like yearly or quarterly sales) but share the same structure. 'Merge Queries' is incorrect because it joins tables horizontally based on a matching key column, which adds columns, not rows. 'Reference' creates a new query linked to a single source query but does not combine it with others. 'Group By' is an aggregation feature used to summarize data within a single table, not to combine multiple tables.