cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

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.

 

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!

2 REPLIES 2
Community Support Team
Community Support Team

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

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
blazko Regular Visitor
Regular Visitor

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

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 Smiley Happy