https://community.fabric.microsoft.com/t5/Developer/Incrementally-load-transactional-data-from-an-API/m-p/2137795#M32398 <P>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?</P> Fri, 15 Oct 2021 15:54:11 GMT Anonymous 2021-10-15T15:54:11Z https://community.fabric.microsoft.com/t5/Developer/Incrementally-load-transactional-data-from-an-API/m-p/2137795#M32398 <P>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?</P> Fri, 15 Oct 2021 15:54:11 GMT https://community.fabric.microsoft.com/t5/Developer/Incrementally-load-transactional-data-from-an-API/m-p/2137795#M32398 Anonymous 2021-10-15T15:54:11Z https://community.fabric.microsoft.com/t5/Developer/Incrementally-load-transactional-data-from-an-API/m-p/2140420#M32427 <P>Hi&nbsp;@Anonymous</a>&nbsp;</P> <P>I think you may refer to this blog to set&nbsp;<SPAN>Incremental refresh for api data source.</SPAN></P> <P><SPAN>For reference:</SPAN></P> <P><A href="https://sqldusty.com/2020/05/20/power-bi-incremental-refresh-with-web-api-data-source/" target="_self">POWER BI INCREMENTAL REFRESH WITH WEB API DATA SOURCE</A></P> <P>&nbsp;</P> <P>Best Regards,<BR />Rico Zhou</P> <P>&nbsp;</P> <P>If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.</P> <P>&nbsp;</P> Mon, 18 Oct 2021 10:02:29 GMT https://community.fabric.microsoft.com/t5/Developer/Incrementally-load-transactional-data-from-an-API/m-p/2140420#M32427 Anonymous 2021-10-18T10:02:29Z