Table or Matrix: limit to display first X rows before loading more?

[OneWithQuestion]

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.

This causes slower page loads, espcially when I have various filters that default to no filtering (or show ALL) and expect the user to start by filtering on region or category, etc, etc...

Instead they have to wait for all 10K rows to populate before the filters and the rest of the page seem to stop loading.

Is there anyway around this or way to just populate the first few hundred rows?

Thanks!

[blazko]

Hi, had same problem. Added index column in querie edit. Then in the table/matrix visual added filter on my main value, choosing Top N, and by value -> index column. Works for me 🙂

[v-yulgu-msft]

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