Forum Discussion

charlestonsityar's avatar
charlestonsityar
Icon for Microsoft rankMicrosoft
Jun 02, 2020

OLAP drill through issue: Maximum number of records to retrieve, change not being applied

Hello,   I'm currently new to this community and would like to ask help with this issue I'm experiencing.   I've been trying to change the number of records to retrieve from the default 1000 ...
Excel Desktop
Need Help
charlestonsityar's avatar
charlestonsityar
Icon for Microsoft rankMicrosoft
Jun 05, 2020

SergeiBaklan 

 

I did a workaround by checking the Connection Properties of an extracted data sheet and editing the Command text box of the number of MAXROWS.

 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 06, 2020

charlestonsityar 

I see, thanks for sharing. By the way, another way to access it is right click on the table->table->edit query

Resources