|
gptkbp:instanceOf
|
data connectivity feature
|
|
gptkbp:alternativeTo
|
Import mode
Live Connection
|
|
gptkbp:canBeBypassedBy
|
importing data into model
|
|
gptkbp:category
|
gptkb:software
Data Connectivity
|
|
gptkbp:combines
|
Import mode (Composite models)
|
|
gptkbp:compatibleWith
|
data in Power BI model
|
|
gptkbp:documentation
|
https://learn.microsoft.com/en-us/power-bi/connect-data/service-directquery
|
|
gptkbp:enables
|
live connection to data source
|
|
gptkbp:hasConnection
|
gptkb:Databricks
gptkb:Oracle
gptkb:Snowflake
gptkb:Teradata
gptkb:MySQL
gptkb:Amazon_Redshift
gptkb:Google_BigQuery
gptkb:PostgreSQL
gptkb:SQL_Server
gptkb:Azure_Synapse_Analytics
gptkb:SAP_HANA
gptkb:Azure_SQL_Database
|
|
https://www.w3.org/2000/01/rdf-schema#label
|
DirectQuery
|
|
gptkbp:introducedIn
|
gptkb:Power_BI
|
|
gptkbp:limitation
|
limited DAX functionality
limited data transformations
performance depends on source
row-level security restrictions
|
|
gptkbp:refreshes
|
data on each query
|
|
gptkbp:requires
|
constant connection to data source
|
|
gptkbp:supports
|
real-time data analysis
large datasets
row-level security
incremental refresh
|
|
gptkbp:usedIn
|
gptkb:SQL_Server_Analysis_Services
gptkb:Microsoft_Power_BI
gptkb:Azure_Analysis_Services
|
|
gptkbp:bfsParent
|
gptkb:Power_BI_Desktop
gptkb:Azure_Analysis_Services
|
|
gptkbp:bfsLayer
|
6
|