Forum Discussion
jo123456
Helper I
Helper IDynamics 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.
jo123456Helper I
Helper Idynamics 365 CRM
Expiscornovus
Most Valuable Professional
Most Valuable ProfessionalYou can also use the Table.GenerateByPage helper function:
https://learn.microsoft.com/en-us/power-query/helper-functions#tablegeneratebypage