what is power query

What is power query?

Query Enhanced Edition (Power Query) is an Excel plug-in and a component of Power BI. Power Query enhances the business intelligence self-service experience by simplifying data discovery, access, and collaboration in Excel.

Query Enhanced Edition (Power Query) is an Excel plug-in and a component of Power BI.

Power Query enhances the business intelligence self-service experience by simplifying data discovery, access and collaboration in Excel.

Power Query is a new plug-in that provides BI professionals and other users with a seamless data discovery and data transformation experience.

Using Power Query, you Can:

Extract data from the data sources you need (such as relational databases, Excel, text and XML files, OData feeds, web pages, Hadoop's HDFS, etc.)

Use the search function to discover relevant data capabilities from both internal and external sources.

Integrate data sources from different sources, establish a good data model, and prepare for further data analysis using Excel, Power Pivot, Power View, and Power Map.

Share the query you created with others so they can easily find it through search.

Supported Operating Systems

Windows 7, Windows 8, Windows Server 2008 R2, Windows Server 2012
Windows Server 2008 R2
Windows Server 2012
Windows 7
Windows 8
Windows 8.1
Windows 10

The following Office versions are supported:

Microsoft Office 2010 Professional Plus 和软件保障
Microsoft Office 2013
Microsoft Office2016 (excel中自带。低版本的需要下载插件。）

Microsoft Power Query for Excel Requires Internet Explorer 9 or higher.

Microsoft Power Query for Excel is available on 32-bit (x86) and 64-bit (x64) platforms, and your selection must match the architecture of your installed version of Office.

For more Excel-related technical articles, please visit the Excel Tutorial column to learn!

The above is the detailed content of what is power query. For more information, please follow other related articles on the PHP Chinese website!