Post31 January, 20142 min de lectura

Power BI: Consultation and transforms your data with Power Query

Power Query

Power Tool BI Business Intelligence (BI) incorporating productivity suite Office 365 and allows us to automate the processes of generation of analytical information.

Power BI includes a collection of features that allow you to visualize data, share discovery and participate in new and intuitive ways of collaboration: Power Query, Power Map, Power Pivot and Power View.

This post is the first in a series of articles that discuss each complements BI Power.

Power Query

It is one of Excel add-ins provided as part of the Power BI tool, it is an ETL tool (stands for Extract, Transform and Load) integrated into Excel to search, transform and combine data from a variety of sources ( both companies, as public data sources online) and with an intuitive and interactive interface.

Power Query

With Power Query Tea

  • Data search and connect through a wide variety of sources.
  • Online conduct searches of a large collection of public data sources, including tables of Wikipedia, a subset of Windows Azure Marketplace, and a subset of
  • Combine data from several sources and sort for further analysis with tools such as Power Pivot, or for viewing tools such as Power View and Power Map.
  • Along with Power View functionality, you can share and manage queries created, and search data within your organization.

Data Sources Power Query

The functionality allows you to enter data into Excel from virtually any type of data sources listed below:

  • From the web
  • From a file – Excel, CSV, XML, text, or a folder that contains files with metadata and links
  • From a database – SQL Server, SQL Azure, Access, Oracle, IBM DB2, MySQL, PostgreSQL, Sybase and Teradata
  • Data from other sources – List of SharePoint, OData source, Windows Azure Marketplace, Hadoop Distributed File System – HDFS, Windows Azure Blob storage, Windows Azure Table storage, Active Directory, Exchange and Facebook.


Want to know more about how BI can help Power?