Forum Discussion

efilipe's avatar
efilipe
Helper IV
6 years ago

Incremental Data Refresh using Rest API / Json- PowerBI Pro

Hi guys,

 

I'd like to know if it's possile to use incremental refresh using API?

 

This is how I call:

 

let
    Source = Json.Document(Web.Contents("https://[website]/api-public/report/query/500?datebegin=20200301&dateend=20200331"), 65001),
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
in
    #"Converted to Table"

 

 

I want to bring all the data but only update it 2 times a day.

 

Is that possible?