Storage Modes¶
| Mode | Data Loading | Performance | Latency | Best For |
|---|---|---|---|---|
| Import | Cached in memory | Fastest | Refresh schedule | Most scenarios, best performance |
| DirectQuery | Query per interaction | Source-dependent | Near real-time | Large datasets, real-time needs |
| Composite | Mixed | Optimized per table | Varies | Combining real-time + historical |
| Direct Lake | On-demand to memory | Fast | Near real-time | Fabric Lakehouse/Warehouse data |