Limit on Rows when I drill down

[Yollies]

However in PowerPivot or PowerBI.com 2 Analyse in Excel the number of rows is limited to 1000 rows. Does anyone know how to override that 1000 number

[Yollies]

Hi. Mine is still greyed our. How do I UNGREY it?

[v-luwang-msft]

HI @Yollies ,

Connections > "ThisWorkbookDataModel" > Properties > "Max. number of records to retrieve" should not be greyed out here.

And refer:

https://social.technet.microsoft.com/Forums/en-US/a20c77e1-0e8d-46ca-9d67-595d4463432e/power-pivot-d... 

https://forum.enterprisedna.co/t/drilldown-1000-row-limit-in-powerpivot-or-powerbi-com-analyse-in-ex... 

Best Regards

Lucien