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.
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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

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