topic Re: Table Pagination in Custom Visuals Development Discussion

Table Pagination

Anonymous — Thu, 30 Mar 2023 09:28:18 GMT

I want create a pagination in table visual powerBI. I dont want to use MAX table visual because we cant change the background visuals for it. How to achieve pagination in table.

Re: Table Pagination

lbendlin — Fri, 31 Mar 2023 23:38:18 GMT

Power BI already does the pagination for you. Queries are run in chunks of 501 rows.

Re: Table Pagination

Anonymous — Wed, 05 Apr 2023 13:34:12 GMT

When I created a table in powerbi by default there is no pagination so I tried to create pagination but unable to find the option in powerbi

Re: Table Pagination

lbendlin — Wed, 05 Apr 2023 14:16:04 GMT

We may be talking about two different things. I was talking about the queries that feed your visuals. These queries are chunked, so when the user scrolls down in a visual that will result in new queries with the next 500 rows etc.

You seem to mean pagination of the actual visual . That is what Power BI Paginated Reports are for. You need to use a special app for that, Power BI Desktop RS (Power BI Report Builder). It is possible to include a paginated report visual in the regular Power BI Desktop but you cannot design it there.

Re: Table Pagination

Anonymous — Wed, 05 Apr 2023 13:53:48 GMT

So can we create a table visual in paginated report and add that as a visual in created dashboard

Re: Table Pagination

lbendlin — Wed, 05 Apr 2023 13:58:49 GMT

Sort of. It is called a "Tablix" visual there, and you can add the resulting .rdl as a "paginated report" visual to your Power BI report.

Re: Table Pagination

Anonymous — Thu, 06 Apr 2023 04:35:26 GMT

Can you guide me how to achieve pagination in table

Re: Table Pagination

lbendlin — Fri, 07 Apr 2023 00:16:30 GMT

I have no expertise in that area but I have registered for a course "Paginated Reports in a Day" to learn how to do that. Maybe you can register for such a course too.