I have an API I want to call that uses pagination. I followed this blog: How to do pagination in Power Query, and got it working on Power BI desktop to get all the data with multiple calls and paging.
When I try and use the M Query in a DataFlow Gen 1 though I get an error that it can't save due to the Dynamic Data Source. This happens even if I update the code from the blog to use Relative Path and Query, like is most often recommended for this error (presumably since even with that it's still a variable number of web calls to get the data).
I see there is a Table.GenerateByPage function available, and have also seen help documents around creating custom connectors.
Before spending time on trying either/both of those options, I thought I would ask this forum what my best path forward is to create a DataFlow Gen1 that calls an API with pagination.
How have folks got this working in their own orgs?
Leyth pointed me in the right direction for using Relative Path. It turns out I was absentmindedly using https://example.com/api in Web.Content instead of just https://example.com (and putting the /api part with the rest of the relative path)