Technical requirements
You should be familiar with the content that we covered in Chapter 9, Working with M, and Chapter 10, Examples of M Usage, before delving into the topics covered here. It goes without saying that you should be proficient at importing various data sources into Excel or Power BI and be comfortable with the Power Query interface, being able to navigate it with ease. You need an internet connection to download the relevant files from GitHub. Also, the code files for this chapter can be found at the following link:
https://github.com/PacktPublishing/Learn-Power-Query
For Code in Action video of this chapter please visit the following link: https://www.youtube.com/watch?v=arwkny-WhIk&list=PLeLcvrwLe186O_GJEZs47WaZXwZjwTN83&index=12&t=0s.