Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Web.content not refreshing on service

Hi everyone, 

 

I have this working for me on Desktop, and not on service.

 

 

(date as text) as table =>
let
    Source = Json.Document(Web.Contents("https://api.ronga.com/",
   [RelativePath="v2/dumplings?filter[begins.gt]="&date&"&page%6Bgross%6D=800" ]
    )),
    data = Source[data],
    #"Converted to Table" = Table.FromList(data, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
in
    #"Converted to Table"

 

 

I have read this article, but doesn't seem to help. https://blog.crossjoin.co.uk/2016/08/23/web-contents-m-functions-and-dataset-refresh-errors-in-power-bi/

 

I'm grateful for any help in advance 

4 Replies