Using Dual Mode dimension in Power BI with ADX data
Dual mode provides the best of using import mode and Direct Query mode for dimensions in PBI By using dual mode, you can reduce significantly the number of queries sent to ADX from PBI. The queries that involve the large tables using Direct Query will still be running entirely in ADX.
