Powerpivot drillthrough limited to 1000 rows in Excel 2013

Powerpivot drillthrough limited to 1000 rows in Excel 2013 by Gavin Campbell

Active

Type:	Bug
ID:	780558
Opened:	3/4/2013 2:02:52 AM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

Hi,

In excel 2010, we could change the maximum number of rows displayed in powerpivot drillthrough in the connection properties.

This appears not to be possible in Excel 2013.

Details (expand)

English

SQL Server 2012 SP1

Analysis Services

Windows 7 Enterprise (SP1)

English

The attached file Fruits2013a contains three rows of data in a Powerpivot table, and a Pivot Table based on that data source. There is an Excel 2010 version Fruits2010

In Office 2013:

Clicking "Data->Connections" brings up the "Workbook Connections" dialog. If I select ThisWorkBookDataModel and click "Properties", I should be able to edit the "Maximum Number of records to retrieve" property in the "OLAP Drill Through" section.

In Office 2010:

The "Properties" dialog is enabled for the "This WorkbookDataModel" connection, and I can use this to change the "Maximum Number of Records to Retrieve".

In Office 2013:

The "Properties" dialog is disabled completely for the "ThisWorkbookDataModel" connection.

The "Properties" dialog is disabled completely for the "ThisWorkbookDataModel" connection.

If I select ThisWorkBookDataModel and click "Properties", I should be able to edit the "Maximum Number of records to retrieve" property in the "OLAP Drill Through" section.

X64

Hyper-V (On-Premise)

File Name	Submitted By	Submitted On	File Size
Fruits2013a.xlsx	Gavin Campbell	3/5/2013	105 KB
Fruits2010a.xlsx	Gavin Campbell	3/5/2013	104 KB

Using the 2010 version of the workbook and Excel 2010, change the max rows returned property to 1 million. Then open the workbook with Excel 2013.

As before, the properties dialog is disabled, but the setting of 1 million rows persists.