Home Dashboard Directory Help
Search

Custom DAX drillthrough does not retain formatting in Excel by Julie Koesmarno


Status: 

Active


1
0
Sign in
to vote
Type: Bug
ID: 774300
Opened: 12/13/2012 2:43:50 PM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

When a custom DAX drillthrough is defined in tabular model, the resultset does not retain the data format. DAX drillthrough seems to create a new data connection to the tabular model, which has command text similar to the following:
EVALUATE SUMMARIZE('Internet Sales',
    "Total Sales",
    'Internet Sales'[Internet Total Sales])

This does not seem to retrieve the formatting into Excel.
Details
Sign in to post a comment.
Posted by Microsoft on 3/6/2013 at 4:53 PM
Thanks a lot for this feedback.
We will consider addressing this issue in a future release and/or update.

Kind regards,
SQL Server Analysis Services Team
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
MDX vs DAX.xlsx 12/13/2012 22 KB