This post is the second in a “mini-series” where I’ll document how I’m working with some different APIs for custom reporting in Power BI and Excel. Today’s post is about Harvest again, but only in general terms. The example is their time_entries endpoint but what I’m really covering today I would term more generically as “iterating over a known number of pages” when calling an…
Continue Reading Jen Kuntz’s Article on their blog
Pagination in Power Query (Part 1)
This post is the second in a “mini-series” where I’ll document how I’m working with some different APIs for custom reporting in Power BI and Excel. Today’s post is about Harvest again, but only in general terms. The example is their time_entries endpoint but what I’m really covering today I would term more generically as “iterating over a known number of pages” when calling an API.
Blog Syndicated with Jen Kuntz’s Permission
More About This Author

- Jen is a self-employed Dynamics GP consultant, based in Southwestern Ontario, Canada. She is a Microsoft MVP in Business Applications (since 2016), a GPUG All-Star and a designated accountant (CPA, CGA).
Array
Dyn365GP28 January 2023Moving website to Hugo
Dyn365GP1 January 20232022 Year in review
Dyn365GP23 December 2022Canadian Payroll 2022 Year End Update
Dyn365GP19 October 2022Resource not found in dictionary error