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

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
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
1K
tjess
T
M
  • Question Question
How to add calculated rows and calculated columns in power pivot table?
Replies
1
Views
2K
Matt Allington
M
D
  • Question Question
Created PT using PQ. But when double clicking for data, only 1000 rows shown
Replies
3
Views
2K
Mark Milan
M
A
  • Question Question
VBA Show detail pivot table row
Replies
0
Views
342
AndreaJ
A
H
  • Question Question
Pivot table drilldowns are limited to 1000 rows.
Replies
0
Views
2K
Hien
H

Forum statistics

Threads
1,223,886
Messages
6,175,193
Members
452,616
Latest member
intern444

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