Getting Data and Power Query Basics

In this lesson, we will learn how to import data in Power BI and understand Power Query basics. We will cover importing Excel and CSV files, renaming columns, changing data types, filtering rows, removing columns, and using Close & Apply. ## Lesson objective In this lesson, we will learn how to import data in Power BI and understand Power Query basics. In the previous lesson, we learned what Power BI is, the difference between Power BI Desktop and Power BI Service, and the concepts of report, dashboard, dataset, data model, and visual. Now we move to the first real stage of the Power BI workflow: To build a report in Power BI, we first need to bring data into Power BI.