Table Pagination

[Anonymous]

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.

[lbendlin]

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

[Anonymous]

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

[lbendlin]

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.

[Anonymous]

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

[lbendlin]

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.

[Anonymous]

Can you guide me how to achieve pagination in table

[lbendlin]

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.