Loading From Data Sources

In this lesson, you will get to know the Power Query commands in Excel 2016 and the different data sources from where you can import data into Power Query.

In this lesson, you will learn how to find the data you need and start a new query that fetches the data from the web and clean the data.

In this lesson, you will learn how you can import data from files, such as CSV and Excel data files. You will also learn how to import multiple CSV files from a folder and multiple sheets from an Excel workbook. In addition, you will learn some relevant tips and tricks.

In this lesson, you will learn how to connect to SharePoint and import data from SharePoint lists and document libraries in both Excel and Power BI Desktop.

In this lesson, you will learn how to connect to a SQL Server database, how to use Select Related Tables feature and the naming conventions. You will also learn joining tables natively in Power Query, the role of query folding and the use native SQL queries.

In this lesson, you will understand various uses of queries in Excel and Power BI Desktop. You will learn how to use queries in different scenarios.