Row limlit option for a report

[Anonymous]

Hi

In Power BI, I observe that we don't have an option to limit the number of rows per page i.e. If I have a report with 200 rows, I would like to limit 20 rows per page and hence have 10 pages in total and have an option displayed somewhere on the report, say, below right corner of the report to navigate to and fro from one page to another page (1,2,3, 4 > etc.). It would be very helpful and greatly appreciated if this feature is implemented in Power BI as soon as possible. Thanks!

[furiocamilo]

Tried different avenues, but this one worked for me.

Opening the Query Editor, then looking for the button "Advanced Editor" and then when opening the coding section, went form this:

let
Source = Json.Document(Web.Contents("https://publicapi.mycompany.com.au/rosters", [Headers=etc...

I added this:

let
Source = Json.Document(Web.Contents("https://publicapi.mycompany.com.au/rosters?limit=1000", [Headers=etc

And it worked!

[Anonymous]

@Anonymous, the R Datatable custom visual works really well for what you're looking for:

https://appsource.microsoft.com/en-us/product/office/WA104381459?src=office&corrid=03976148-a5a2-467f-8967-f7148a185a74&omexanonuid=b6ebf3f6-6c29-4f7c-85c3-714d9dd5e6b7

[Anonymous]

Sonny,

Thank you! It is a very good alternative. However, I am looking for basic page navigation and row-limit option for a simple Power BI grid report. I am pretty sure that Power BI doesn't have this feature yet and I hope they will implement it in the future releases. Thanks again for poiting me to this wonderful alternative!

[Aron_Moore]

You could add an index column to the dataset and filter each tab of the report to an index range or some label for index groups.

Then use buttons to implement your navigation requirements.

[Anonymous]

Hi Aron,

I really appreciate the workaround. What if the scenario is not 200 rows but 2000 rows or more? Definitely it wouldn't be advised to have 100 tabs or more as pages and navigate between them. Don't we have an better option in Power BI to achieve this requirement? Please find attcahed for the kind of page navigation I ma looking for. Thanks!

[Aron_Moore]

Are the multiple pages required?

Using the index method you could use a slicer to filter the entirity of a one page report to show only the data from "page 1", "page 2", etc.

[Anonymous]

Aron,

Thank you! It is a very good work-around. However, I am looking for basic page navigation and row-limit option for a simple Power BI grid report. I am pretty sure that Power BI doen't have this feature yet and I hope they will implement it in the future  releases. Thanks again for the work-around!