Power Query was introduced first in Excel 2010 as an addin and then it was ported to Power BI. The Power Query Editor is packed with a lot of features for extracting and transforming data that includes AI capabilities.

In this session, you will learn some basic to advanced features in Power Query like importing files from a folder, easy looping, webscraping from a single and multiple pages and so on.

You will also learn some Power Query Best Practices.