PowerBI Servie Issue with Dynamic Data Source, Pagination Issue

Perfect, thank you Idendlin the schedualed refreshes works now on power bi service! 

Here is my new code: 

let
// Define the date range
dateRange = "2018-01-01,3024-06-20",

// Define the base URL (common part of the URL)
baseUrl = "https://api.<>",

// Function to get data from a specific page using RelativePath
GetPage = (page as number) as table =>
let
// Define the relative path with the specified page
relativePath = "<>" & dateRange & "&page=" & Text.From(page),

// Define the headers
headers = [
#"Content-Type" = "application/json",
Authorization = "<>"
],

// Send the request using Web.Contents with BaseUrl and RelativePath
response = Web.Contents(baseUrl, [
RelativePath = relativePath,
Headers = headers
]),

// Parse the JSON response
json = Json.Document(response),

// Extract the items from the JSON response
items = json[items],

// Transform the list of items to a list of records
transformedItems = List.Transform(items, each [
Customer_Name = _[customer_snapshot][company_name],
Invoice_Number = _[number],
Invoice_Date = _[document_date],
Invoice_Amount = _[amount],
Paid_Amount = _[paid_amount],
Currency = _[currency],
Payment_Date = _[paid_at]
]),

// Convert the list of records to a table
resultTable = Table.FromRecords(transformedItems)
in
resultTable,

// Function to get all data using pagination
GetAllData = () =>
let
// Fetch the first page to get the total number of pages
firstPageResponse = Json.Document(Web.Contents(baseUrl, [
RelativePath = "<>" & dateRange & "&page=1",
Headers = [
#"Content-Type" = "application/json",
Authorization = "<>"
]
])),
totalPages = firstPageResponse[pages],

// Initialize a list to store all pages
allPages = List.Generate(
() => 1,
each _ <= totalPages,
each _ + 1,
each GetPage(_)
),

// Combine all pages into a single table
allData = Table.Combine(allPages)
in
allData,

// Call the function to get all data
Custom = GetAllData(),

// Change column types
#"Changed column type" = Table.TransformColumnTypes(Custom, {
{"Customer_Name", type text},
{"Invoice_Number", type text},
{"Invoice_Date", type text},
{"Invoice_Amount", Int64.Type},
{"Paid_Amount", Int64.Type},
{"Currency", type text},
{"Payment_Date", type text}
})
in
#"Changed column type"