Powerquery - how to increase pivot drill-down beyond 1000 rows?

L

Legacy 452786

Guest
Hi,

With regular pivot tables it's possible to increase the double-click data drill-down too >1000 rows by clicking Data->Queries and connections->Right click on ThisWorkbookDataModel->Properties->and increasing the "maximum number of records to retrieve" under "OLAP drill-though".

However if the data model is created with Powerquery, this seems to be disabled.

ThisWorkbookDataModel is not found under Queries and Connections. And right clicking on any of the queries shows this the feature as grayed out.

Ideas?
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
You must log in or register to reply here.

Similar threads

T
  • Solved
OLAP Pivot Table Expand/Collapse Buttons in Column Fields not Working
Replies
1
Views
917
tjess
T
M
  • Question
How to add calculated rows and calculated columns in power pivot table?
Replies
1
Views
1K
Matt Allington
M
danhendo888
  • Question
Created PT using PQ. But when double clicking for data, only 1000 rows shown
Replies
3
Views
2K
Mark Milan
M
H
  • Question
Pivot table drilldowns are limited to 1000 rows.
Replies
0
Views
1K
Hien
H
D
  • Question
Saving and Re-using a Data Model based on other Excel Worksheets
Replies
0
Views
2K
danrofohio
D

Forum statistics

Threads
1,214,968
Messages
6,122,506
Members
449,089
Latest member
RandomExceller01

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top