O'Reilly logo

Collect, Combine, and Transform Data Using Power Query in Excel and Power BI, First Edition by Gil Raviv

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 3Combining Data from Multiple Sources

The attempt to combine wisdom and power has only rarely been successful and then only for a short while.

Albert Einstein

IN THIS CHAPTER, YOU WILL

  • Append tables from a few specified data sources

  • Append multiple Excel workbooks from a folder

  • Append multiple worksheets from an Excel workbook

While Albert Einstein’s quote may be correct, and wisdom and power have only rarely been combined successfully, with Power Query you have the power to combine multiple sources to gain a lasting wisdom. In this chapter you will learn how to combine multiple tables in various levels of complexity to gain insights from the combined datasets.

Chapter 2, “Basic Data Preparation Challenges,” discusses different scenarios ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required