Forum Discussion
sceccolini
1 year agoFrequent Visitor
Online refresh not supported - Web.Contents, RelativePath and Query
Hello Community, I need your support to troubleshoot my issue with the online refresh not enabled. I defined the following function 'ExecuteREST' to invoke a REST with pagination by using Web.Con...
- 1 year ago
Hi all,
I resolved this by having a unique function rather than a dedicated REST client:
let BaseUrl = "MY BASE URL", GetPage = (PageNumber as number) => let Response = Json.Document(Web.Contents( BaseUrl, [ RelativePath = "MY RELATIVE PATH", Query = [ param = "MY PARAM", page = Text.From(PageNumber) ], Timeout = #duration(0, 0, 10, 0) // Imposta il timeout a 10 minuti ] )), Results = try Response[entries] otherwise null in Results, GetAllPages = List.Generate( () => [PageNumber = 1, Results = GetPage(1)], each [Results] <> null and List.Count([Results]) > 0, each [PageNumber = [PageNumber] + 1, Results = GetPage([PageNumber] + 1)], each [Results] ), CombinedResults = List.Combine(List.Transform(GetAllPages, each _)), ResultTable = Table.FromList(CombinedResults, Splitter.SplitByNothing(), null, null, ExtraValues.Error), #"Expanded Column1" = Table.ExpandRecordColumn(ResultTable, "Column1", {"content"}, {"content"}), #"Expanded content" = Table.ExpandRecordColumn(#"Expanded Column1", "content", {"properties"}, {"properties"}), ....
Anonymous
1 year agoNot applicable
Hi sceccolini
My suggestions are as follows for your reference:
- please try not to use dynamically constructed URLs in Web.Contents, and consider using relative paths and query parameters.
- Set the data source privacy level.
The following document is for your reference:
Solved: Web.Contents with dynamic file URL - Microsoft Fabric Community
Hope this helps.
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.