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.
With the Power Query Editor Open, at the bottom left area click on
where it says "Column profiling based on top 1000 rows", and change
to "Column profiling based on entire data set" This will load all rows
the data and not just the top 1000 rows.