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...
linsd
Microsoft Employee
Microsoft EmployeeThis feature request is critically important because Direct Lake mode is designed for high-performance, low-latency access to massive datasets in Fabric Lakehouses, making it ideal for enterprise-scale analytics. However, without drillthrough support in Excel PivotTables, users are forced to switch contexts or write custom DAX/MDX queries to inspect underlying data, which disrupts workflows and reduces productivity—especially for business analysts who rely heavily on Excel for ad-hoc exploration and validation. Enabling this would ensure parity with Import and DirectQuery modes, accelerate Direct Lake adoption, and empower more seamless, end-to-end data investigation without compromising on speed or scale.
