Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
There was a Rest Default limitation with the content provider. Increasing it resolved thee issue. Appreciate the feedack
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!
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?
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
User | Count |
---|---|
93 | |
83 | |
77 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |