Hi, I'm using Excel 365 subscription at work. I need to drill down from a cell in my Power Pivot pivot table which has 3,424 records but drilling down returns a truncated sheet of the first 1,000 rows. Clicking the Data ribbon, Existing Connections, then right clicking the relevant query, Edit Connection Properties, shows the OLAP Drill Through but the 'Maximum number of records to retrieve' is greyed out. Could you advise how to return the full number of rows? Thanks
Solved by B. S. in 29 mins