Forum Discussion
Dynamics 365
I am connected to CRM for a report and only 5000 records are being returned when I have 6000. Is there a workaround to get all the rows in the data? Thank you.
Hi jo123456,
Most APIs would have some kind of pagination/paging functionality. What are you using for your connection? Dynamics 365 CRM?
Here is an example for Dataverse paging:
https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/query/page-results
dynamics 365 CRM
You can also use the Table.GenerateByPage helper function:
https://learn.microsoft.com/en-us/power-query/helper-functions#tablegeneratebypage
