Data Explorer Add-in

Removed in 2016
This was replaced with built-in Get & Transform features in Excel 2016.
Added in Excel 2010 and previously called Data Explorer
Previously called Data Explorer this enhances self-service business intelligence for discovering, combining and refining data from multiple sources.

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.

The Data Explorer add-in provided 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

PowerQuery Tab


Get External Data
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 - Drop-Down contains the commands: From Excel, From CSV, From XML, From Text, From Folder From Database - Drop-Down contains the commands: From SQL Server, From Windows Azure SQL, From Access Database, From Oracle, From IBM DB2 From Azure - (?)
From Database -
From Other Souces - Drop-down contains the commands: From SharePoint List, From OData Data Feed, From Windows Azure Marketplace, Blank Query Recent Sources - (?)

Excel Data
From Table - Create a new table that is linked to the selected Excel table or named range

Merge - Merge or join tables in the active workbook
Append - Append two queries from this workbook
Locale -
Fast Combine -

Workbook Queries (called Managed Queries in beta)
Show Pane (?) - Displays the "Workbook Queries" task pane (called Workbook in beta ?)
Shared - removed
Launch Editor (Added April 2015) - Launches the Query Editor application window

Settings (called Machine Settings in beta) Workbook Settings
Data Source Settings - Displays the "Data Source Settings" dialog box
Update - Install the latest version of Power Query
Options - Displays the "Query Options" dialog box showing various options, including Workbook Settings such as Fast Combine and Locale.

Power BI (called Organisation in beta)
Data Catalog Search -
My Data Catalog Queries -
Sign In -

Send Feedback -
Help -
About -

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext