A Power BI setting under which one table works both ways, DirectQuery and Import, so for each query Power BI can choose whichever is more efficient. Models that combine modes like this are called composite.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Dual storage mode in context, with comparison tables and the common traps.
Terms in this definition
- Power BI
Microsoft's analytics and reporting service. It reaches data held on-premises through the on-premises data gateway.
- Event
Table in Log Analytics where entries from Windows event logs are kept.
- DirectQuery
Power BI connection mode in which reports fetch data from the source in real time; Direct Lake outperforms it.
- LIKE
Compares strings with a pattern that can contain the % and _ wildcards. Because it only understands character patterns, searching big volumes of text this way is much slower than using full-text search.
Related terms
- Real-time DirectQuery partition
Turning this incremental refresh option on makes a table hybrid: rows newer than the refresh period are read through an extra DirectQuery partition. Premium, PPU or Embedded is needed, and Dual storage mode is advisable for related tables.