Power Query
E36075
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.
All labels observed (14)
How this entity was disambiguated
This entity first appeared as the object of triple T277284 — resolving that mention is where its identity was fixed. The disambiguator weighed these candidate entities and picked the highlighted one (or “None”, minting a new entity). This is how homonymy is resolved: the same surface form can point to different entities.
NED1
Entity disambiguation (via context triple)
gpt-5-mini-2025-08-07
Target entity: Power Query Context triple: [Power BI, hasComponent, Power Query]
-
A.
Power BI
Power BI is a Microsoft business analytics and data visualization platform used to transform, analyze, and present data through interactive dashboards and reports.
-
B.
pandas
pandas is a popular open-source Python library that provides powerful, easy-to-use data structures and tools for data analysis and manipulation.
-
C.
Power Automate
Power Automate is a Microsoft cloud service that enables users to create automated workflows between apps and services to synchronize files, get notifications, and streamline repetitive tasks.
-
D.
Excel
Excel is a widely used spreadsheet software by Microsoft that enables data organization, analysis, visualization, and basic to advanced analytics through formulas, functions, and tools like PivotTables.
-
E.
Tableau
Tableau is a widely used data visualization and business intelligence software platform that enables users to analyze, explore, and present data through interactive dashboards and reports.
- F. None of above. chosen
- G. Unsure - the case is ambiguous/there is not enough information to decide.
NED2
Entity disambiguation (via description)
gpt-5-mini-2025-08-07
Target entity: Power Query Target entity description: 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.
-
A.
Power BI
Power BI is a Microsoft business analytics and data visualization platform used to transform, analyze, and present data through interactive dashboards and reports.
-
B.
pandas
pandas is a popular open-source Python library that provides powerful, easy-to-use data structures and tools for data analysis and manipulation.
-
C.
Power Automate
Power Automate is a Microsoft cloud service that enables users to create automated workflows between apps and services to synchronize files, get notifications, and streamline repetitive tasks.
-
D.
Excel
Excel is a widely used spreadsheet software by Microsoft that enables data organization, analysis, visualization, and basic to advanced analytics through formulas, functions, and tools like PivotTables.
-
E.
Tableau
Tableau is a widely used data visualization and business intelligence software platform that enables users to analyze, explore, and present data through interactive dashboards and reports.
- F. None of above. chosen
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 ⓘ |
How these facts were elicited
The pipeline generated the facts above by prompting gpt-5.1 with this entity's name + description and the instruction below.
Instruction
You are a knowledge base construction expert. Given a subject entity and a description of it, return factual statements that you know for the subject as a JSON list of dictionaries(triples), where keys must be "subject", "predicate" and "object". The number of facts may be very high, between 25 to 50 or more, for very popular subjects. For less popular subjects, the number of facts can be very low, like 5 or 10. # Requirements - If you don't know the subject at all, return an empty list. - If the subject is not a named entity, return an empty list. - Include at least one triple where predicate is "instanceOf". - Do not get too wordy. - Separate several objects into multiple triples with one object.
Input
Subject: Power Query Description of subject: 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.
Referenced by (26)
Full triples — surface form annotated when it differs from this entity's canonical label.
this entity surface form:
Power Query M
this entity surface form:
Power Query engine
this entity surface form:
Power Query Editor
this entity surface form:
Excel Get & Transform Data
this entity surface form:
Azure Data Factory Power Query activity
this entity surface form:
Power Query Online
this entity surface form:
Microsoft Power Query
this entity surface form:
Excel Power Query
this entity surface form:
Power Query Online
this entity surface form:
Azure Data Factory Power Query activity
this entity surface form:
Power Query Formula Language
this entity surface form:
Power Query M formula language
this entity surface form:
Power Query M
this entity surface form:
Excel Power Query
this entity surface form:
M (Power Query Formula Language)
this entity surface form:
Power Query Editor