Drill Through not working on SharePoint Deployed workbook


  • I am not sure if this is a PowerPivot question or rather just a Pivot table issue. 

    I have a Power Pivot data model and I have created  pivot table on the model. 

    When I click on the Beta Region / Actuals (the yellow) cell, I get two different experiences between the Excel client and the SharePoint Excel Services version. 

    In the thick client, I drill to detail onto a new sheet.  On the web version, nothing happens.  I can "explore" data, but it is more about navigation and not drilling to details. 

    Any idea how to get the SharePoint Excel Services to drill through to the detail stored in the Power Pivot data model.



    Tuesday, November 19, 2013 12:31 AM