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.
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 ⓘ |
Referenced by (1)
Full triples — surface form annotated when it differs from this entity's canonical label.