Storage modes

Storage modes define where the data lives: Import (in-memory copy, fast), DirectQuery (queries sent to the source at every interaction, up-to-date data but slower) and Dual mode. The choice depends on volume, desired freshness and the source's performance.

Example

Import for a monthly sales model; DirectQuery for data that must be refreshed continuously.

Related concepts

The whole glossary