3.3 Storage Modes: Import vs DirectQuery vs Live Connection
This is one of the most important concepts in Power BI and a very common interview question.
Import mode
Data is copied into Power BI's in-memory engine (VertiPaq), highly compressed.
- Pros: fastest performance, full DAX and Power Query features, works offline in Desktop.
- Cons: data is only as fresh as the last refresh; model size limits apply (e.g. 1 GB per model in the Service with Pro, larger with PPU/capacity); refresh takes time for big data.
DirectQuery mode
Data stays in the source. Every time a visual is displayed or filtered, Power BI sends a query to the source database.
- Pros: near real-time data; very large data volumes; data does not need to be copied.
- Cons: slower visuals (depend on source speed); some Power Query transformations and DAX functions are limited; heavy load on the source database.
Live connection
Power BI connects to an existing semantic model – a published Power BI semantic model (formerly called dataset) or an Analysis Services model. You do not build a model in your file; you only build the report on top of the shared model.
- Pros: one "single version of truth" model reused by many reports; central governance.
- Cons: you cannot change the model in Power Query (you can add report-level measures). To extend it you convert it into a composite model (संमिश्र मॉडेल – Import आणि DirectQuery एकत्र) using DirectQuery for Power BI semantic models (अहवालांसाठी सामायिक डेटा मॉडेल). Module 4.7 compares DirectQuery and Live connection in detail.
Composite model and Dual mode
A composite model mixes Import and DirectQuery (डेटा स्रोतातच राहतो, प्रत्येक क्लिकला थेट क्वेरी) tables in one model. Tables can have the storage mode Import, DirectQuery or Dual (behaves as Import or DirectQuery depending on the query). Set it in Model view › select table › Properties › Advanced › Storage mode.
Direct Lake
In Microsoft Fabric there is a newer mode called Direct Lake, which reads Delta tables from OneLake directly with Import-like speed. You will meet it fakt when working with Fabric lakehouses or warehouses.
| Feature | Import | DirectQuery | Live connection |
|---|---|---|---|
| Where data lives | Inside the Power BI model | In the source | In another semantic model / Analysis Services |
| Performance | Fastest | Depends on source | Depends on the remote model |
| Data freshness | As of last refresh | Near real-time | Depends on remote model |
| Power Query transformations | Full | Limited (must fold to source) | Not available |
| DAX calculated columns | Yes | Yes, with limits | No (report measures only) |
| Typical use | Most reports | Very large or real-time data | Enterprise shared models |
Rule of thumb
Start with Import unless you have a clear reason not to (data too large, real-time need, or policy that data must not be copied). Most professional Power BI reports use Import mode.
Storage modes cha vishay Module 4 madhe aankhi detail madhe yeil, tyamule atta fakt basic farak lakshat theva.
Ravindra Bagale's Tip
Mala khup vela disata ki learners pick DirectQuery "because the data will be live" and then suffer slow visuals on small datasets. Start with Import unless there is a clear reason (khup large data, near real-time need, data must stay at the source). You can explain the choice in interviews with this reasoning. Dhyan rakho!