Forum Discussion
Get Data => Blank Query, Only returns 200 rows
There was a Rest Default limitation with the content provider. Increasing it resolved thee issue. Appreciate the feedack
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
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-msftCommunity Support
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
There was a Rest Default limitation with the content provider. Increasing it resolved thee issue. Appreciate the feedack