SSAS 2017 and Excel356 - Custom Drill Through Action

DataNinja 21 Reputation points


we currently using SSAS 2017 (multidimensional) and I'm trying to leverage multi select for drillthroughs that we're building out for our reporting.
However, when I try to use the actions with multiple items from a filter selected, I get the familiar error saying "Drillthrough action is not supported when multiple items are selected in a report filter or slicer." Just to provide a little more context, I'm trying to call actions which return a rowset.

Is there a way to use the drilltrough with filtered items?


SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,256 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Lukas Yu -MSFT 5,816 Reputation points

    Are you dealing with multidimension cube or tabular model?