Power Pivot Table - Show Details

jeancake

Board Regular
Joined
Nov 3, 2008
Messages
54
I noticed that when i create a power pivot table and click on the totals to show the details it's limited to 1000 rows. Is there a way to display all the records like I would in a regular pivot table?
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

GraH

Well-known Member
Joined
Mar 22, 2020
Messages
613
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
It actually makes sence there is a limitation on the drill down. PP can hold much more data then a sheet can. It allows to view a sample only.
You can set it to the max number of rows of a sheet though in the connection properties, section OLAP drill through.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,651
Messages
5,549,204
Members
410,905
Latest member
Extjel
Top