Power BI incremental refresh from Shopcada store using API

Thanks for the response.

However, the problem is still unresolved, so I’m providing more context below.

I'm currently using Power BI Pro (not Premium). In Power BI Desktop, I’m getting a query folding warning. But when I publish the report to the Power BI Service, the refresh fails completely.

I'm suspecting the issue is related to query folding, but I’m not sure how to resolve it under the limitations of the Pro license. I'm happy to share the M code if needed.

Can  help guide me on how to fix this issue or work around it? Any support would be appreciated!

Thank you.

#Mcode:

let
    StartDate = DateTime.ToText(RangeStart, "yyyy-MM-dd"),
    EndDate = DateTime.ToText(RangeEnd, "yyyy-MM-dd"),
    APIKey = "xxxxxxxxxxxxxxxxxxxxxxxxxxx",
    PageSize = 100,
    MaxPages = 2000,
    DelaySeconds = 1,
    GetPage = (PageNum as number) =>
        let
            Response = Json.Document(
                Web.Contents("xxxxxxxxxxxxxx", [
                    RelativePath = "xxxxxxxxxxxx",
                    Query = [
                        page = Text.From(PageNum),
                        limit = Text.From(PageSize),
                        created_at_min = StartDate,
                        created_at_max = EndDate
                    ],
                    Headers = [#"xxxxxxxxxxx" = APIKey],
                    ManualStatusHandling = {429}
                ])
            ),
            Status = Value.Metadata(Response)[Response.Status]?,
            Result = if Status = 429 then error "Too Many Requests" else Response,
            Orders = Result[orders],
            Delayed = Function.InvokeAfter(() => Orders, #duration(0, 0, 0, DelaySeconds))
        in
            Delayed,
    PageNumbers = List.Numbers(0, MaxPages),
    AllPages = List.Transform(PageNumbers, each try GetPage(_) otherwise null),
    FilteredPages = List.RemoveNulls(AllPages),
    Combined = List.Combine(FilteredPages),
    ToTable = Table.FromList(Combined, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    Expanded = Table.ExpandRecordColumn(ToTable, "Column1", Record.FieldNames(Combined{0})),
    ExpandedWithDate = Table.TransformColumnTypes(Expanded, {{"created_at", type datetimezone}}),
    AdjustedCreatedAt = Table.AddColumn(ExpandedWithDate, "created_at_adjusted", each DateTimeZone.RemoveZone([created_at]), type datetime),
    FilteredRows = Table.SelectRows(AdjustedCreatedAt, each [created_at_adjusted] >= RangeStart and [created_at_adjusted] < RangeEnd)
in
    FilteredRows