Limit the display of rows in a table visual

[disney_batista]

I have a scenario where one page of my report contains a table visualization. This table has about 40 columns. The number of rows varies depending on the client's dataset, but can exceed 15 million rows. What are the ways to control/limit the number of rows loaded/displayed on screen for the user without having to change the granularity of the database data?

What are the alternatives, with their pros and cons? The goal is to minimize the use of Fabric capacity when displaying this visualization.

I tried using table pagination via DAX, but the rows aren't dynamic.

And the paginated report option doesn't solve the problem, since it loads the data from the entire database.

[v-saisrao-msft]

Hi @disney_batista,

Checking in to see if your issue has been resolved. let us know if you still need any assistance.

Thank you.

[v-saisrao-msft]

Hi @disney_batista,

Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.

Thank you.

[v-saisrao-msft]

Hi @disney_batista,

We haven’t heard back from you in a while regarding your issue. let us know if your issue has been resolved or if you still require support.

Thank you.

[v-saisrao-msft]

Hi @disney_batista,

Thank you @SamsonTruong, for your helpful insights.

Additionally, here are the links for your reference:

Optimization guide for Power BI - Power BI | Microsoft Learn

Create and use the paginated report visual - Power BI | Microsoft Learn

Performance and scalability considerations for paginated reports in Power BI service - Power BI | Mi...

Hope this helps

Thank you.

[SamsonTruong · Accepted solution]

Hi @disney_batista ,

There are several methods to reduce the rows displayed in your table visual:

• One option would be to apply a TOPN filter to your visual in the filter pane. This can restrict the amount of data shown in your table.
• Another option would be to leverage the "Apply all" setting in your slicers. This will allow your users to select how they want to filter the data before having the slicers filter down the dataset, saving on Fabric compute. (https://learn.microsoft.com/en-us/power-bi/create-reports/buttons-apply-all-clear-all-slicers)
  
  

You could also leverage a combination of these methods.

If this helped, please mark it as the solution so others can benefit too. And if you found it useful, kudos are always appreciated.

Thanks,

Samson

Connect with me on LinkedIn

Check out my Blog

Going to the European Microsoft Fabric Community Conference? Check out my Session