Drillthrough action does not work on tabular model

Jan 11 at 8:16 AM
I have troubles getting Drillthrough actions to work on tabular model. The error states that the connection is not open and it is referring to a folder (D:\Codeplex) for the tabular actions plugin. Does anybody experiencing the same problem?
Coordinator
Jan 11 at 9:00 PM
What version of Visual Studio and what version of BIDS Helper?

If it's VS2015 and you're using the latest 1200 compatibility Tabular models, customizing drillthrough actions aren't supported.

If it's SQL vNext and 1400 compatibility Tabular models, you can try out the new native drillthrough customization feature in SSDT:
https://blogs.msdn.microsoft.com/analysisservices/2016/12/16/whats-new-for-sql-server-vnext-on-windows-ctp-1-1-for-analysis-services/

If you're using < 1200 compatibility level models in VS2015 and are getting errors, click furmangg and send me an email. I have a beta build that fixes that bug.
Mar 10 at 10:09 PM
I am trying to use the tabular actions editor (in excel use additional actions to kick off a SSRS report) on a 1103 compatibility version of the cube deployed to a 2016 ssas server. I don't see anything in the additional actions right click (in excel). What am I doing wrong. I see the tabular action in visual studio.


BIDS Helper 2016 Visual Studio Extension v2.0.1
Visual studio version 14.0.25431.01
ssas version 13.0.1601.5
Coordinator
Mar 12 at 3:57 PM
Can you post all the settings used on the action definition?
Mar 13 at 3:10 PM
Edited Mar 13 at 3:20 PM
I can (see link below), to add some additional information I am using the exact same model I deployed to a 2012/14 SSAS server using 2010 data tools that works (drill through) just fine. I pulled the cube in VS 2015 from the 2012/2014 server (create project as "import from server")

When I deploy to 2016, I get a blank additional actions tab.

screen shot of tabular actions settings
Coordinator
Mar 13 at 11:42 PM
Have you tried redeploying the model after opening the Actions dialog? I can imagine the upgrade might have lost the actions except for our backup in an annotation.

Are you connecting in Excel to the base model or the perspective? I see it's not part of the perspective.

The action setup looks fine to me.
Mar 15 at 1:25 PM
Edited Sun at 9:40 PM
Yes I tried that last night, still nothing in the tabular actions editor. Any thoughts? And I am connecting to the main model, not the perspective.