#DATA MASHUP UPDATE#

Power Query can connects to set of data sources and read data from them. Actually there are some features in Power Query engine that not yet has been implemented through GUI, but they are available through M (formula language). However the Power Query formula language is much more powerful than the GUI. The graphical tool has list of transformations that can be applied on a data set, and it also supports different data sources. The graphical tool has two major setup versions one embedded in Power BI Desktop tool, and the other one as an Add-In for Excel. The engine comes with a formula language and a graphical tool. Power Query is a data extraction and transformation engine.

#DATA MASHUP UPDATE#

Power Query is on a regular and frequent update plan by Microsoft’s Power BI Data Integration team Data Explorer then renamed to Power Query at July 2013, and from that time it had lots of enhancement on the product. Data Explorer has been released as public preview for the first time at February 2013. Power Query previously named as Data Explorer. What are features of Power Query Premium?.What are requirements to run Power Query?.What types of works can be done with Power Query?.In this section you will read an introduction to Power Query. 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 chapter you will learn about What Power Query is, and what are different types of sources that Power Query can connect. When you get data in Power BI you actually use Power Query Component.

Data mashup