Excel Pivot Tables have the capability to drill-through (double-clicking numbers in the pivot table), which direct lake models don't seem to support. In the models themselves, we can define detai...
Drillthough is one of the most commonly used features of excel in our org. Directlake is marketed as the "best of both worlds" of DirectQuery and Import mode, and yet it doesn't support this crucial feature which works in Import mode. IMO this is a critical feature if you want users to move from import mode to DirectLake.
