Get Data => Blank Query, Only returns 200 rows

[hernanjv]

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?

[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]

In Power Query Editor, Power BI does not get all data for reviewing. Once you have applied these queries, all of your data would be loaded into Power BI Data module

[hernanjv]

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?

[v-juanli-msft]

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?

https://social.technet.microsoft.com/Forums/en-US/08dd7519-7370-4421-8ac1-ca28f7f63ab1/power-query-o...

Best Regards

Maggie

[hernanjv · Accepted solution]

There was a Rest Default limitation with the content provider. Increasing it resolved thee issue. Appreciate the feedack