cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hernanjv Frequent Visitor
Frequent Visitor

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?

1 ACCEPTED SOLUTION

Accepted Solutions
hernanjv Frequent Visitor
Frequent Visitor

Re: 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

4 REPLIES 4
Jessica_Seiya Established Member
Established Member

Re: Get Data => Blank Query, Only returns 200 rows

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 Frequent Visitor
Frequent Visitor

Re: Get Data => Blank Query, Only returns 200 rows

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?

Community Support Team
Community Support Team

Re: Get Data => Blank Query, Only returns 200 rows

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 Frequent Visitor
Frequent Visitor

Re: 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