Connections

Existing Connections
SS - default dialog

PowerQuery Tab

SS

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

Combine
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 -

Help
Send Feedback -
Help -
About -