Schedue refresh not available

[sceccolini]

Hello, community,

I have the following Power BI code to iterate through pages on a REST service:

    Source = (PageNumber as number) =>
        let
            Url = "https://myServiceUrl&page=" & Text.From(PageNumber),
            Response = Json.Document(Web.Contents(Url)),
            Results = try Response[entries] otherwise null
        in
            Results,
    GetAllPages = List.Generate(
        () => [PageNumber = 1, Results = Source(1)],
        each [Results] <> null and List.Count([Results]) > 0,
        each [PageNumber = [PageNumber] + 1, Results = Source([PageNumber] + 1)],
        each [Results]

The data is fetched correctly, but when I publish in a workspace, the automatic refresh is denied because of the following error:

You can't schedule refresh for this semantic model because the following data sources currently don't support refresh:
Data source for Query1

Do you have any suggestion to fix this in a way I can schedule the automatic refresh when published?

Thanks

[v-zhangtin-msft]

Hi, @sceccolini 

Please check out the link below and I hope it helps.

Troubleshooting unsupported data source for refresh - Power BI | Microsoft Learn

Solved: You can't schedule refresh for this semantic model... - Microsoft Fabric Community

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@sceccolini I believe you need a gateway.

[sceccolini]

Hello,

I didn't say but I configured a web gateway for my root REST URL https://myserviceurl

Thanks

Simone