Forum Discussion
Solved
Get Data => Blank Query, Only returns 200 rows
Get Data => Blank Query, Only returns 200 rows. Is the 200 row limit a settings, filter, or configuration? How can I receive all rows in the table?
There was a Rest Default limitation with the content provider. Increasing it resolved thee issue. Appreciate the feedack
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!