Forum Discussion
Excel 365 Power Pivot Table Double Click shows only first 1000 rows
Foodd suggestion – Excel 365 in Query Editor make change at bottom left of pane. This allows you to copy all the rows and columns in the Query Editor Table and paste outside of the Editor. Unfortunately, it didn’t fix my issue.
Solution :-
In Excel, Issue if create Pivot Table from Data Model – Drill through default on Pivot Table (double click from within Pivot Table) only shows first 1000 rows.
Get around solution: In Excel 365, on the Ribbon go to Data. Then, click on Queries & Connections. Go to ‘Connections’.
Right Click to see Connections Properties.
Change the value from 1000 in OLAP Drill through to suit. Then Save.
This should then work for you.
*** The Difficulty I had I could not get the Connection Properties to show the connection. Need to see ThisWorkbookDataModel. The change needs to be made here. I kept seeing the Query Properties.
Foodd suggestion – Excel 365 in Query Editor make change at bottom left of pane. This allows you to copy all the rows and columns in the Query Editor Table and paste outside of the Editor. Unfortunately, it didn’t fix my issue.
Solution :-
In Excel, Issue if create Pivot Table from Data Model – Drill through default on Pivot Table (double click from within Pivot Table) only shows first 1000 rows.
Get around solution: In Excel 365, on the Ribbon go to Data. Then, click on Queries & Connections. Go to ‘Connections’.
Right Click to see Connections Properties.
Change the value from 1000 in OLAP Drill through to suit. Then Save.
This should then work for you.
*** The Difficulty I had I could not get the Connection Properties to show the connection. Need to see ThisWorkbookDataModel. The change needs to be made here. I kept seeing the Query Properties.
For me, sometimes "ThisWorkbookDataModel" shows up and sometimes it does not (i.e., only the "WorksheetConnection" shows up. When I create a pivot table from another sheet in the workbook, I DO select "Add to Data Model".