Web JSON Api returns only first 4000 records

[Anonymous]

Hi, 
I have an issue. I have the below api which I run in Power Query and it passes parameters for Start Date and End Date. But whatever Start and End Date I provide, Only the first 4000 records is fetched, What should I do to get all the records for a specific start and end date in Power Bi?

Api which I run in Power BI

= Json.Document(Web.Contents("https://www.xyz.com/api/rest/v1/entries?startdate="&Date.ToText(StartDate, "yyyy-MM-dd")&"&enddate="&Date.ToText(StartDate, "yyyy-MM-dd")&"", [Headers=[Accept="application/json", Authorization="Bearer eyJraWQixyz"]]))

thanks, Ankku

[dax]

Hi ankku, 

As  I know, the limit of rows show be 10000, you could try &max-results=10000 in API to see whether it work or not. You could refer to “max-results” parameter for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@dax So even that will not solve the problem, the article says we have to use the pagination feature to get more records, Have anyone in the community done that and have been able to get all records? Sure Microsoft would have given a thought and have some ways to do it in Power Bi.

thanks,
Ankku