Forum Discussion
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
5 Replies
Jessica, appreciate the response. Unfortunatly - when I 'close and save' the query im still left with 200 rows. You mention - all of your data would be loaded into Power BI Data module. Could you clarify how this is accomplished?
Hi hernanjv
As tested on my site, it is possible to get more than 200 rows when Get Data => Blank Query.
Which is your datasource?
Could you share the code in advanced editor?
Here is a similar problem, could you check if it helps you?
Best Regards
Maggie
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=etcAnd it worked!
