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.

Try in SPARQL Jump to: Surface forms Statements Referenced by

All labels observed (14)

Label Occurrences
Power Query canonical 7
Excel Power Query 3
Azure Data Factory Power Query activity 2

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 (26)

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

Power BI → hasComponent → Power Query ⓘ
Excel → supports → Power Query ⓘ
subject surface form: Microsoft Excel
M → alsoKnownAs → Power Query ⓘ
this entity surface form: Power Query M
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
M → executedBy → Power Query ⓘ
this entity surface form: Power Query engine
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 ⓘ
Microsoft Dataverse dataflows → usesTechnology → Power Query ⓘ
Power BI Service dataflows → supports → Power Query ⓘ
this entity surface form: Power Query Online
Power BI Service dataflows → basedOn → Power Query ⓘ
M language → usedIn → Power Query ⓘ
this entity surface form: Microsoft Power Query
M language → usedIn → Power Query ⓘ
this entity surface form: Excel Power Query
M language → usedIn → Power Query ⓘ
this entity surface form: Power Query Online
M language → usedIn → Power Query ⓘ
this entity surface form: Azure Data Factory Power Query activity
M language → officialName → Power Query ⓘ
this entity surface form: Power Query Formula Language
M language → alsoKnownAs → Power Query ⓘ
this entity surface form: Power Query M formula language
M language → alsoKnownAs → Power Query ⓘ
this entity surface form: Power Query M
Microsoft BI stack → hasComponent → Power Query ⓘ
this entity surface form: Excel Power Query
Microsoft Dataverse → integratesWith → Power Query ⓘ
Power BI Desktop (Report Server optimized) → supportsLanguage → Power Query ⓘ
this entity surface form: M (Power Query Formula Language)
Power BI Desktop (Report Server optimized) → hasUserInterface → Power Query ⓘ
this entity surface form: Power Query Editor