Forum Discussion
OneWithQuestion
8 years agoPost Prodigy
Table or Matrix: limit to display first X rows before loading more?
I have noticed with the Table and Matrix if I have say, 10,000 rows of data it seems to load all 10K rows. Instead of loading say the first 250 and then waiting for someone to scroll down. Th...
v-yulgu-msft
8 years agoMicrosoft Employee
Hi OneWithQuestion,
I'm afraid this is not possible to achieve. When we apply any filter to slicer or report/page/visual level filter, actually, the Power Query that loads data is not executed. The dataset is not updated. So, we have to load all data records and display them in data view before displaying a report.
Regards,
Yuliana Gu