What is hybrid model?

< 1 min read

Hybrid model in Power BI combines Import and DirectQuery for the same table.
It is mainly used for large fact tables with both historical and recent data.
Older data is stored in Import mode for fast performance.
Recent or incremental data is accessed using DirectQuery for near real-time reporting.
In one project, historical sales were imported, and current month sales used DirectQuery.
This improved dashboard speed while still showing up-to-date numbers.
Hybrid model balances performance and data freshness.
It is commonly implemented using incremental refresh with real-time data enabled.

Power BI Essentials