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

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

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,510
Messages
5,548,488
Members
410,840
Latest member
Kar3ousse
Top