Paginated Rest APIs using low-/no-code

Hi dolphinantonym , Thank you for reaching out to the Microsoft Community Forum.

You're right to check, but nothing has changed. Dataflow Gen2 still doesn’t support paginated APIs in a low- or no-code way. You can connect to APIs in Power Query, but only if the full dataset comes in a single response. There's still no support for handling offset, page tokens, or loops inside the dataflow.

So yes, the old thread still applies. The only real option is to use a notebook (Python or Spark) to handle pagination and then load the data into a Lakehouse.

Use a notebook to load data into your lakehouse