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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
