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 detail rows expressions just fine, and the DAX DETAILROWS function also works fine, but the MDX equivalent that Excel generates does not.
Idea is to add capability for Pivot Table drill-through against Direct Lake semantic models.
Thanks!
3 Comments
- 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.
linsdMicrosoft Employee
This 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.- Looks like this is shipped! Thank you!
