Forum Discussion

sceccolini's avatar
sceccolini
Frequent Visitor
1 year ago
Solved

Schedue refresh not available

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

 

4 Replies