Power Query

Removed in 2016 (added in 2010)
Previously called Data Explorer
Previously called Data Explorer this enhances self-service business intelligence for discovering, combining and refining data from multiple sources.
This was replaced with built-in Get & Transform features in Excel 2016.
Has its own catalog and on premises data integration.
Assists with self service business intelligence
Provides access to any web / online data set.
Enhances the self-service Business Intelligence experience by simplifying data discovery, access and collaboration.

Download from Microsoft website

The PowerQuery add-in provides an intuitive user interface for data discovery from both public aand corporate data sources.
Can be used to get data from a web service or web query.
It also has a (US only) public search feature
Power Query can now be manipulated using VBA.

PowerQuery Tab


Online Search - Lets you get a list of all the available data sources (both internal and external) that match a specific critieria
From Web -
From File -
From Database -
From Other Souces -
From Table -
Merge -
Append -
Locale -
Fast Combine -
Data Source Settings -
Update -
Options -

© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited

Top ▲