Search notes:

Get & Transform (Power Query)

Get & Transform was known as Power Query in Excel releases before 2016.

Microsoft touts Power Query as a

Data Connectivity and Data Preparation technology that enables business users to seamlessly access data stored in hundreds of data sources and reshape it to fit their needs, with an easy to use, engaging, and no-code user experience.

Power Query is natively integrated into

Microsoft Power BI
Excel (found in the Ribbon/menu under Data -> Get & Transform Data)
Microsoft SQL Server Data Tools for Visual Studio
Microsoft Dataverse (formerly Common Data Service)

The Power Query Editor allows to

preview data
apply over 300 data transformations

Mashing-up data

Mashing-up data refers to the process of filtering and combining data from possible multiple data sources.

Such mash up processes can be expressed with the Power Query M formula language.

Apparently, the Microsoft Power Query OLE DB provider (Microsoft.Mashup.OleDb) seems to be suited for mashing-up data.

See also

The language formula M is a so-called Mashup query language that was created for Get & Transform and allows to programmatically define the steps that can also be formulated graphically in the Get & Transform editor.

Data preparation

Power Query M formula language

The workbookQuery object of the Excel Object Model.

The registry key HKEY_CURRENT_USER\Software\Microsoft\Office\application_version\PowerQuery.

Displaying the result of a Power Query program in an Excel ListObject.

%LOCALAPPDATA%\Microsoft\Office\v.v\PowerQuery\Users.zip