Forum Discussion

hernanjv's avatar
hernanjv
Frequent Visitor
7 years ago
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?
Need Help
  • hernanjv's avatar
    hernanjv
    7 years ago

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

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

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-occassionally-connects-seems-to-load-but-returns-only-200-rows-with-1-error?forum=powerquery

 

 

 

Best Regards

Maggie

hernanjv's avatar
hernanjv
Frequent Visitor
7 years ago

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