Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Table Pagination

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.

7 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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's avatar
        lbendlin
        Super User
        3 years ago

        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.