Get startedGet started for free

Appending queries

Each year of sales data for Northwind traders is stored in a different Excel file. Your manager has asked you to combine all the sales data to be able to analyze total sales for the years 1996-1998.

More information about appending queries can be found in this MSFT Learn article.

You will make use of the append query feature in Power Query to accomplish this.

This exercise is part of the course

Data Transformation in Power BI

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise