Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

← SQL Server

Error with Detail Rows Expression when used with Excel drillthrough

With a SSAS Tabular model on compatibility Level 1400, I have defined a Default Rows Expression to allow the client to obtain specific columns when connecting with an Excel pivot table but in Excel 2016 the following error is returned when the drillthrough is executed:

"RETURN clause cannot be used with the DRILLTHROUGH statement when a DetailRows expression is already defined on the measure 'Transaction Count'"

I have defined the Default Detail Rows Expression at the table level and have not defined a Detail Rows expression on any measures individually. My understanding is that if no expression is defined on the measure it will use the table level (which is what I want).

No matter what measure I try to drillthrough on the error is the same (but the measure name is different of course).

SQL Server Version: 14.0.1.439
Excel Version: 16.0.4639.1000 (32-bit)

8 votes
Sign in
(thinking…)
Sign in with: Microsoft
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

John shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

6 comments

Attach a File
Sign in
(thinking…)
Sign in with: Microsoft
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment

SQL Server: Bugs

Categories

Feedback and Knowledge Base

(thinking…)
Hosted by UserVoice