Forum Discussion
Drill Through Capability in Excel Pivot Table lost
When calling the details function on a pivot table (source is an OLAP-cube on SSAS) I am no more able to drill through. I got this error message: RETURN clause cannot be used with DRILLTHROUGH state...
The issue with drill-through functionality in Excel PivotTables when querying an SSAS cube is related to the interaction between the `DRILLTHROUGH` statement and the `DetailRows` expression. To resolve this, check the cube definitions, update metadata, modify the DetailRows expression, consult SSAS documentation, adjust PivotTable settings, clear cache, verify compatibility, use an alternative method like SQL Server Management Studio (SSMS), or contact Microsoft Support for further guidance.