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.