Incremental Data Refresh using Rest API / Json- PowerBI Pro

[efilipe]

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?

[amitchandak]

Refer if one these can help:

https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/

https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only

[amitchandak]

@efilipe , is it resolved?