DirectQuery
E702180
DirectQuery is a data access mode in Microsoft analytics services that allows real-time querying of underlying data sources without importing the data into the model.
All labels observed (1)
| Label | Occurrences |
|---|---|
| DirectQuery canonical | 1 |
How this entity was disambiguated
This entity first appeared as the object of triple T7984633 — 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: DirectQuery Context triple: [Azure Analysis Services, supports, DirectQuery]
-
A.
Power Query
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.
-
B.
Quick BI
Quick BI is Alibaba Cloud’s business intelligence and data analytics platform that enables users to visualize, analyze, and share insights from their data.
-
C.
Power View
Power View is an interactive data visualization and reporting tool from Microsoft that enables users to create dynamic, presentation-ready dashboards and reports.
-
D.
Power Pivot
Power Pivot is an Excel data modeling and analysis add-in that enables users to create sophisticated data models, relationships, and DAX calculations for business intelligence reporting.
-
E.
Aqua Data Studio
Aqua Data Studio is a database management and development environment that provides tools for querying, visualizing, and administering a wide range of relational and NoSQL databases.
- 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: DirectQuery Target entity description: DirectQuery is a data access mode in Microsoft analytics services that allows real-time querying of underlying data sources without importing the data into the model.
-
A.
Power Query
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.
-
B.
Quick BI
Quick BI is Alibaba Cloud’s business intelligence and data analytics platform that enables users to visualize, analyze, and share insights from their data.
-
C.
Power View
Power View is an interactive data visualization and reporting tool from Microsoft that enables users to create dynamic, presentation-ready dashboards and reports.
-
D.
Power Pivot
Power Pivot is an Excel data modeling and analysis add-in that enables users to create sophisticated data models, relationships, and DAX calculations for business intelligence reporting.
-
E.
Aqua Data Studio
Aqua Data Studio is a database management and development environment that provides tools for querying, visualizing, and administering a wide range of relational and NoSQL databases.
- F. None of above. chosen
Statements (49)
| Predicate | Object |
|---|---|
| instanceOf |
Microsoft analytics services feature
ⓘ
Power BI feature ⓘ data access mode ⓘ |
| accesses | underlying data sources directly ⓘ |
| affects |
query folding behavior
ⓘ
report refresh behavior ⓘ |
| benefit |
centralized data governance
ⓘ
near real-time analytics ⓘ no data duplication ⓘ reduced memory usage in Power BI service ⓘ |
| caches | metadata and schema only ⓘ |
| canBeCombinedWith | Import mode in composite models ⓘ |
| contrastsWith |
Composite models
ⓘ
Import mode ⓘ |
| dataStorage | data remains in source system ⓘ |
| developedBy | Microsoft ⓘ |
| doesNotRequire | importing data into the model ⓘ |
| enables |
live connection to data source
ⓘ
up-to-date data in reports ⓘ |
| governedBy | Power BI capacity and throttling limits ⓘ |
| hasLimitation |
limited DAX functionality compared to Import mode
ⓘ
limited calculated tables support ⓘ limited use of quick insights ⓘ performance dependent on source system ⓘ query timeouts risk ⓘ restricted modeling capabilities ⓘ row-level security complexity ⓘ |
| introducedIn | SQL Server Analysis Services 2012 era ⓘ |
| queryExecutionLocation | source database ⓘ |
| requires |
careful query design
ⓘ
high-performance data source ⓘ optimized database indexes ⓘ |
| supports | real-time querying ⓘ |
| supportsFeature |
row-level security at source
ⓘ
single sign-on to some data sources ⓘ |
| typicalDataSources |
Azure SQL Database
NERFINISHED
ⓘ
Azure Synapse Analytics NERFINISHED ⓘ Oracle databases NERFINISHED ⓘ SAP BW NERFINISHED ⓘ SAP HANA NERFINISHED ⓘ SQL Server NERFINISHED ⓘ Snowflake NERFINISHED ⓘ Teradata NERFINISHED ⓘ |
| usedFor |
large datasets that cannot fit in memory
ⓘ
scenarios requiring current transactional data ⓘ |
| usedIn |
Azure Analysis Services
NERFINISHED
ⓘ
Fabric semantic models ⓘ Microsoft Power BI NERFINISHED ⓘ SQL Server Analysis Services NERFINISHED ⓘ |
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: DirectQuery Description of subject: DirectQuery is a data access mode in Microsoft analytics services that allows real-time querying of underlying data sources without importing the data into the model.
Referenced by (1)
Full triples — surface form annotated when it differs from this entity's canonical label.