Connection error with Standard Business Central API (pagination)

Hi all,

I'm working with Business Central and I use Power Bi to do reporting on the data.

The connection with a bearer token works perfect, but the result of this API is always 20.000 rows because this is the 'limit' per page for Business Central.

So for now I only receive 20.000 rows in my model, can anyone help me to fetch the rest of the data please ?

here the code I use:

let
// Token
AccessToken = Acces_Token(),

// Start Date and End Date
StartDateText = Date.ToText(RangeStart, "yyyy-MM-dd"),
EndDate = DateTime.Date(DateTime.LocalNow()),

// Construct the initial query string
QueryString = "?$filter=postingDate ge " & StartDateText & ",

// Define API Base URL and Relative Path
BaseUrl = "https://api.businesscentral......../",
RelativePath = "API OF BUSINESS CENTRAL",

// Function to fetch data from the API, handling pagination
GetData = (Url as text, AccumulatedResults as list) =>
let
// Request the data from the API
Response = try Json.Document(Web.Contents(BaseUrl, [
RelativePath = Url,
Headers = [Authorization = "Bearer " & AccessToken]
])) otherwise null,

// Extract the records from the API response
Records = if Response <> null and Record.HasFields(Response, "value") then Response[value] else {},

// Accumulate the results from the current page
NewAccumulatedResults = List.Combine({AccumulatedResults, Records}),

// Check if there's a next page (nextLink)
NextLink = if Response <> null and Record.HasFields(Response, "odata.nextLink") then Text.Replace(Response[odata.nextLink], BaseUrl, "") else null
in
// If there is a next page, recursively fetch the next set of data
if NextLink <> null then @GetData(NextLink, NewAccumulatedResults) else NewAccumulatedResults,

// Initial API request with the filter for the start date and top limit
FullUrl = RelativePath & QueryString,

// Fetch all data recursively
AllResults = GetData(FullUrl, {}),

// Convert the results into a table
TableResult = Table.FromRecords(AllResults)
in
TableResult

Thanks in advance