Bucle de Power BI REST de API

@Pitou
Bueno, en base a la información que nos proporcionó:

let
    // Define API request as a reusable function
    request = (offset as number, limit as number) => 
        Json.Document(
            Web.Contents(
                "https://sxXXXX/",
                [
                    RelativePath = "timesheet-lines",
                    Query = [
                        sort = "id-",
                        offset = Text.From(offset),
                        limit = Text.From(limit),
                        api_key = "8e529cc63e220c2c7a02eb706986bbbd"
                    ]
                ]
            )
        ),

    // Get total number of records
    getTotal = request(0, 1)[total], // Assumes the API returns a `total` field in the response

    // Set page size and calculate total pages
    pageSize = 1000,
    totalPages = Number.RoundDown(getTotal / pageSize),

    // Generate list of pages
    pages = {0..totalPages},

    // Fetch data for each page
    populatePages = List.Transform(
        pages,
        each request(_ * pageSize, pageSize)[data] // Assumes `data` contains the records
    ),

    // Combine all pages into a single list
    expandPages = List.Combine(populatePages)
in
    expandPages