Incrementally load transactional data from an API

[jamesd1985]

Good afternoon, I are currently trying to get Invoice data from the Xero apis, however I do not wish to pull in every record upon refresh of the dataset. Is it possible to incrementally load in only new/amended records via an API in Power BI/Power Query?

[v-rzhou-msft]

Hi @jamesd1985 

I think you may refer to this blog to set Incremental refresh for api data source.

For reference:

POWER BI INCREMENTAL REFRESH WITH WEB API DATA SOURCE

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.