Forum Discussion
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
- parry2k
Super User
sceccolini I believe you need a gateway.
- sceccoliniFrequent Visitor
Hello,
I didn't say but I configured a web gateway for my root REST URL https://myserviceurl
Thanks
Simone
- AnonymousNot applicable
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.
- sceccoliniFrequent Visitor