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?
Solved! Go to Solution.
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?
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?