With Power Query, you can
- Find and connectdata across a wide variety of sources.
- Merge and shape data sources to match your data analysis requirements or prepare it for further analysis and modeling by tools such as Power Pivot and Power View.
- Create custom views over data.
- Use the JSON parser to create data visualizations over Big Data and Azure HDInsight.
- Perform data cleansing operations.
- Import data from multiple log files.
- Create a query from your Facebook likes that render an Excel chart.
- Pull data into Power Pivot from new data sources, such as XML, Facebook, and File Folders as refreshable connections.
- With Power Query 2.10 and later, you can share and manage queries as well as search data within your organization.
Power Query Data Sources
- Web page
- Excel or CSV file
- XML file
- Text file
- Folder
- SQL Server database
- Microsoft Azure SQL Database
- Access database
- Oracle database
- IBM DB2 database
- MySQL database
- PostgreSQL Database
- Sybase Database
- Teradata Database
- SharePoint List
- OData feed
- Microsoft Azure Marketplace
- Hadoop File (HDFS)
- Microsoft Azure HDInsight
- Microsoft Azure Table Storage
- Active Directory
- Microsoft Exchange