When you get data in Power BI you actually use Power Query Component. In this chapter you will learn about What Power Query is, and what are different types of sources that Power Query can connect. Power Query has also great list of transformations that can be applied on the data set as well (which will be covered in next chapter), and the Power Query formula language M can be used for complex and powerful data transformation situations (will be covered in a chapter after). In this section you will read an introduction to Power Query. You will learn; What Power Query is? What types of works can be done with Power Query? What are requirements to run Power Query? What are features of Power Query Premium?
Getting Data is the first experience of working with Power BI. You can connect to many data sources on-premises or on cloud. For some data sources you can have a live or direct connection, for some connection works offline. For some connections you need a gateway or connector to be installed. In this module you will learn everything about get data experience of Power BI.
Best way to get started with Power Query is through a demo. In this section you will see a demo of getting data of best seller movies from Box Office Mojo. You will see how data will be fetched from web, and you will learn how to apply data transformation through graphical user interface of Power Query. In this demo you will also learn how this data can be combined with another data source, and the result of that be visualized in Power BI Desktop.
Excel plays an important role as one of the data sources for Power BI. There are some tips to consider before using Excel as a source in Power BI. In this video you will learn which parts of Excel can be imported and which parts will be ignored. You will also learn how to Import an existing Power Pivot model into Power BI Desktop.