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 statement when a DetailRows expression is already defined on the measure..
There is a similar thread on the fabric community. However I do not query a Power BI cube but a SSAS cube (which is – from Excel as client – similar indeed). There is a DetailRows expression defined in the cube; it was working up to the Office 365 MSO Version 2402.
Anyone who encounter same issue and/or find a workaround without rolling back to a previous version?
Best regards
Emmanuel
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 statement when a DetailRows expression is already defined on the measure..There is a similar thread on the fabric community. However I do not query a Power BI cube but a SSAS cube (which is – from Excel as client – similar indeed). There is a DetailRows expression defined in the cube; it was working up to the Office 365 MSO Version 2402.Anyone who encounter same issue and/or find a workaround without rolling back to a previous version?Best regardsEmmanuel Read More