Shabnam Watson - Hybrid Tables in Power BI

Hybrid tables, a new addition to Power BI, are a game changer in that they provide the best of both worlds by allowing one table to have two storage modes at the same time!

Before the introduction of Hybrid tables, each table in Power BI could only have one storage mode: Import which loaded data entirely into Power BI’s memory or DirectQuery which left data in the back-end data source. When working with near real time requirements, Power BI developers had to use tables with DirectQuery; however, DirectQuery by itself could result in less than optimum query performance for large datasets and put a burden on the backend system.
Hybrid tables combine the two storage modes and therefore provide improved query performance for historical data by loading them into memory (Import) and provide near real time capability for recent data (DirectQuery).

Join this session to learn about different table storage modes in Power BI including the newest Hybrid option and how to use it.