Forum Discussion
Incrementally load transactional data from an API
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?
1 Reply
Hi Anonymous
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.