Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Row limlit option for a report

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 i...
Need Help
furiocamilo's avatar
furiocamilo
New Member
5 years ago

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!