Excel 2019 ProPlus Powerpivot drilldowns are limited to 1000 rows.
In excel 2016, editing this number by adjust it in OLAP drill through
In Excel 2019 this is not possible anymore, option in the connection is grayed out.
Is there another way to increase drilldown max rows to beyond 1000 rows?
Thanks
In excel 2016, editing this number by adjust it in OLAP drill through
In Excel 2019 this is not possible anymore, option in the connection is grayed out.
Is there another way to increase drilldown max rows to beyond 1000 rows?
Thanks