Blog Post

FastTrack for Azure
3 MIN READ

Implementing Pagination with the Copy Activity in Microsoft Fabric

Sally_Dabbah's avatar
Sally_Dabbah
Icon for Microsoft rankMicrosoft
Aug 31, 2023
Introduction: APIs often return a large amount of data. Pagination allows you to retrieve a manageable subset of this data at a time, preventing unnecessary strain on resources and reducing the lik...
Updated Aug 31, 2023
Version 1.0
data & ai
Sviana's avatar
Sviana
Copper Contributor
Jan 22, 2025

I have the exact same issue, so far I have not found how to dynamically assign the upper value to the range, and Range function from Dynamic Expression can have only 2 parameters (start/end).

King-D's avatar
King-D
Copper Contributor
Feb 13, 2025

This is what has worked for me. Leave the End parameter blank and so it increments 1 page at a time. For the EndCondition pagination parameter, "$.result" would then be the array from which you are extracting the data. If your array is called "data" then your value would be "$.data". The Value for that parameter should be "Empty".