Power Query

E36075
data connectivity technology data transformation tool

Power Query is a data connection and transformation tool used to import, clean, and reshape data from various sources before analysis in Microsoft Power BI and other Microsoft products.

Jump to: Surface forms Statements Referenced by

Observed surface forms (8)

Surface form Occurrences
Azure Data Factory Power Query 1
Azure Data Factory Power Query activity 1
Excel Get & Transform Data 1

Statements (50)

Predicate Object
instanceOf data connectivity technology ⓘ
data transformation tool ⓘ
canConnectTo Azure ⓘ
surface form: Azure services

CSV files ⓘ
Excel files ⓘ
OData feeds ⓘ
SharePoint ⓘ
surface form: SharePoint lists

databases ⓘ
local files ⓘ
online services ⓘ
text files ⓘ
web data sources ⓘ
category business intelligence tool ⓘ
self-service BI technology ⓘ
developer Microsoft ⓘ
hasComponent M language ⓘ
Power Query self-linksurface differs ⓘ
surface form: Power Query Editor
integratedIn Power Query self-linksurface differs ⓘ
surface form: Azure Data Factory Power Query activity

Power Query self-linksurface differs ⓘ
surface form: Excel Get & Transform Data

Microsoft Dataverse dataflows ⓘ
surface form: Power Apps dataflows

Power BI Service dataflows ⓘ
surface form: Power BI Dataflows

Power BI ⓘ
surface form: Power BI Desktop
offers graphical user interface for data transformation ⓘ
step-based transformation model ⓘ
output Excel tables ⓘ
Power BI data model tables ⓘ
data tables ⓘ
partOf Excel ⓘ
surface form: Microsoft Excel

Power BI ⓘ
surface form: Microsoft Power BI

Microsoft Power Platform ⓘ
stores transformation steps as query definitions ⓘ
supports adding calculated columns ⓘ
appending queries ⓘ
combining data from different sources ⓘ
connecting to multiple data sources ⓘ
data type conversion ⓘ
filtering data ⓘ
grouping data ⓘ
incremental data refresh in Power BI ⓘ
merging queries ⓘ
parameterized queries ⓘ
pivoting columns ⓘ
query folding ⓘ
unpivoting columns ⓘ
usedFor data cleaning ⓘ
data import ⓘ
data preparation for analysis ⓘ
data reshaping ⓘ
data transformation ⓘ
uses M language ⓘ

Referenced by (12)

Full triples — surface form annotated when it differs from this entity's canonical label.

M → alsoKnownAs → Power Query ⓘ
this entity surface form: Power Query M
M → executedBy → Power Query ⓘ
this entity surface form: Power Query engine
Power BI → hasComponent → Power Query ⓘ
Power Query → hasComponent → Power Query self-linksurface differs ⓘ
this entity surface form: Power Query Editor
Power Query → integratedIn → Power Query self-linksurface differs ⓘ
this entity surface form: Excel Get & Transform Data
Power Query → integratedIn → Power Query self-linksurface differs ⓘ
this entity surface form: Azure Data Factory Power Query activity
Power Map → relatedTo → Power Query ⓘ
Excel → supports → Power Query ⓘ
subject surface form: Microsoft Excel
M → usedIn → Power Query ⓘ
M → usedIn → Power Query ⓘ
this entity surface form: Excel Power Query
M → usedIn → Power Query ⓘ
this entity surface form: Microsoft Excel Get & Transform Data
M → usedIn → Power Query ⓘ
this entity surface form: Azure Data Factory Power Query