Teo Lachev takes us through the Dual storage mode now available in Power BI:
As the name implies, the dual storage mode is a hybrid between Import and DirectQuery. Like importing data, the dual storage mode caches the data in the table. However, it leaves it up to Power BI to determine the best way to query the table depending on the query context. Consider the following schema where all tables come from the same data source. Let’s assume the following configuration:
-
FactInternetSales is imported
-
FactResellerSales is DirectQuery
-
DimDate and DimProduct are Dual
Read on for more.