Custom DAX drillthrough does not retain formatting in Excel

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

Active

Type:	Bug
ID:	774300
Opened:	12/13/2012 2:43:50 PM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

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 (expand)

English

SQL Server 2012 - Developer Edition

Analysis Services

Windows 7 Professional

English

1. Using Adventure Works tabular model, define a custom drillthrough (rowset) using BIDS Helper 1.6 or manually. Save, release and process the tabular model.
EVALUATE SUMMARIZE('Internet Sales',
    "Total Sales",
    'Internet Sales'[Internet Total Sales])
2. Create a Pivot table in Excel 2010.
3. Click on the newly created drillthrough. This will create a new Workbook / data connection - by default "Connection1" that contains Command Text:
EVALUATE SUMMARIZE('Internet Sales',
    "Total Sales",
    'Internet Sales'[Internet Total Sales])

In the new sheet, the resultset returned is in a plain format - no money / currency related (based on the "Steps to Reproduce" above).

Formatting should be kept in (or passed along into) Excel when:
1. a data connection with DAX is defined
2. a custom drillthrough with DAX is defined

X64

File Name	Submitted By	Submitted On	File Size
MDX vs DAX.xlsx	Julie Koesmarno	12/13/2012	22 KB

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