restpowerbipaginationpowerquerym

Data Flow Gen1 with Dynamic Data Source/Pagination


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?


Solution

  • 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)