In the previous blog post, I went through the basic concepts behind the Append operation found in Power Query for Excel and Power BI.
In that post, we only used 2 files and it was pretty straightforward to simply click the Append queries button to combine both queries like so:
A more complex scenario
but what happens when you have multiple files? Let’s say 12 files. 1 for each month of the year.
Excel specialist turned into BI specialist using the latest tools from Microsoft for BI – Power BI. He is the co-author of ‘M is for Data Monkey’, blogger and also Youtuber of powerful Excel video Tricks.
He has been recognized as a Microsoft Most Valuable Professional (MVP), is a Microsoft Certified Professional (MCP – MCSA: BI Reporting), a Microsoft Certified Trainer (MCT), and is one of the international pioneers in Power Pivot, Power Query and Power BI.